Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi -
I have been reading through the different solutions for showing the expected total in a table for an if statement but haven't been able to apply it to my particular report. Possibly because I have measures created from other measures.
The right two columns are my issue. Started with far right column and only wanted to show lines over $300. I used this if statement.
Solved! Go to Solution.
Hey @melaniemdavis
You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"
HI @melaniemdavis,
I'd like to suggest you take a look at following blog about measure total level calculation:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Hey @melaniemdavis
You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"
User | Count |
---|---|
82 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
97 | |
86 | |
68 |