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.
Hi guys,
I'm struggling to create a measure to extract the following information from one grid:
What is being displayed on this grid, are the values for 3 different measures. What I want to do is to create a two new measure that gives me a sum of the measure "T/O" and "Margin" when the measure "Margin %" is bigger than 11%.
I tried a lot of things, and the closer that I got was this measure with an IF statement:
The idea is to create a card visual that displays the sum of T/O and Margin, which is giving me a blank result:
https://imgur.com/a/JJ687pV
When I try to use a grid to see if the measure is working fine, it won't give me the sum of the values calculated by my metric:
https://imgur.com/gmrspVb
Does anyone know how can I fix this? I will be much appreciated.
PS: Apologies for the links of the images instead of actual screenshots, but for some reason I weren't allowed to post the image on this post.
Thanks in advance!
HI @Miguel05,
AFAIK, measure formula calculation result is based on its row contents.
If you want to summarize the current result, you need to manually simulation its row contents and category groups in a variable table and add a new field with a measure formula to this table. After these steps, you can use iterator aggregate functions on this variable table to get correspond measure summary results.
If you confused about coding formula, please share some dummy data with dax formula and expected result to help us clarify your requirement and do test on it.
Regards,
Xiaoxin Sheng
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |