Forum Discussion
Revenue aggregation with a filter and KPI Switch
Hi all,
We do have a Calculation Group where the user is able to select which KPI they want to see (e.g. Revenue, Revenue %, etc.)
For each available KPI there must be a different filter applied, in this case the Sum of Revenue per Brand must be over 10000 (Row Total over 10000). The Revenue Table is on a more granular level and needs to be aggregated.
From our knowledge and abilities this did not seem to be possible via the Filter Pane. We came to the conclusion, to apply the filter directly on the Calculation Item of the Calulation Group. Unfortuneately we were not able to find the correct DAX Expression for our problem. Can someone help with this problem? Preferably we do not want to add another table to the model, maybe a temporary table via CALCULATETABLE( ) is the solution?
Revenue is calculated as following: SUM(Revenue[Revenue])
Available in Revenue Table:
Date, Brand ID, Segment ID, Revenue
Left Column: Brands
Right Columns: Customer Segments + KPI Switch
Anonymous,
You can now achieve this with a Fields Parameter instead of a calculation group.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
As far as "Row Total over 10000", you could add a condition to the measure that displays the amount only if it exceeds 10000. Can you provide the DAX for this measure?
1 Reply
- DataInsights
Super User
Anonymous,
You can now achieve this with a Fields Parameter instead of a calculation group.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
As far as "Row Total over 10000", you could add a condition to the measure that displays the amount only if it exceeds 10000. Can you provide the DAX for this measure?