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.
How do I create a Power BI ...READ MORE
If you want to build Power BI ...READ MORE
To allow Power BI visuals to change ...READ MORE
If the user selects only one value ...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.