93149/how-to-create-summary-table-based-selected-filters-slicers
I am trying to create a visualization based on the quantity and purchase value with data close to the ones given below. But the quantity must be the sum of products purchased by a retailer for the selected period. These products may change the selected items in the filter.
Here are the steps you can follow:
1. Create a measure.
Quantity_new = CALCULATE(SUM('Table'[Quantity]))
Value_new = CALCULATE(SUM('Table'[Value]))
2. Result.
You can download the PBIX file from here.
If the user selects only one value ...READ MORE
I used dummy data to show how to ...READ MORE
Follow the below steps: 1. Select the map ...READ MORE
Adding weekly start date & end date ...READ MORE
Do you want to show a table ...READ MORE
Click on edit queries after loading source ...READ MORE
Hi, There are the steps which you can ...READ MORE
Splitting columns in Power BI using the ...READ MORE
To do so, follow these steps: From the ...READ MORE
If the tables are related, this is ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.