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...
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?
DataInsights
Super User
Super UserAnonymous,
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?