Forum Discussion
How do I calculate multiple measures based on data that ignore visual filter context?
I have a dataset storing lists of items that appeared on invoices along with my desired result.
I am wanting to create the following measures in Power BI and display them in a table:
- [Alert Total] (Measure #1) calculates the total for a given indicator on a given invoice (e.g., "B" on Invoice #1001).
- [All Alerts Total] (Measure #2) calculates the total for all items on an invoice that were flagged with an "indicator" ([Indicator]<>"")
- [Invoice Total] (Measure #3) calculates the total for the invoice as a whole.
I assume this will utilize a CALCULATE function in Power BI, but I cannot for the life of me get it to work as the measures always respect the current filter context.
Anonymous try following for all alerts
All Alerts Total = CALCULATE( [Sum], ALLEXCEPT( Table1, Table1[Invoice] ), NOT ISBLANK( Table1[Indicator] ), NOT Table1[Indicator] = "" ) * DIVIDE( [IsIndicator], [IsIndicator] )
6 Replies
- parry2k
Super User
Anonymous just to confirm your data is from A to D and you want to achieve F to J, correct?