Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Solved! Go to Solution.
@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] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous just to confirm your data is from A to D and you want to achieve F to J, correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous solution attached, I have created 5 measure, 3 for alert and 2 base measures. cheers!!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you for providing that example. Very excited about applying these measures.
I did notice one thing in the attached file. The All Alerts Total measure does not appear to be calculating what all of the alerts total up to. For 1001, the desired result would be 43 since there are three alerts and each item total adds up to 43 (25 + 10 + 8). Is there any way to correct this?
@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] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |