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 the following data table:
I want a matrix that always compares the amounts to the big amounts. I created a measure that I thought would always give me the total of all the Big amounts:
How do I get AllBig to show for all Sections?
This example isn't realistic but I tried to simplify the issue to the smallest set of data that showed the problem.
Solved! Go to Solution.
Hi, @Whatever1 , if you want such a result,
you might want to try this measure
AllBig =
CALCULATE (
SUM ( [Amount] ),
Table1[Group] = "Big",
ALLEXCEPT ( Table1, Table1[Color] )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi, @Whatever1 , if you want such a result,
you might want to try this measure
AllBig =
CALCULATE (
SUM ( [Amount] ),
Table1[Group] = "Big",
ALLEXCEPT ( Table1, Table1[Color] )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thank you! I have been banging my head against the wall with this and just couldn't figure out why it wasn't working.
@Whatever1 , Try like
AllBig = calculate(sum([Amount]),filter(Table1,Table1[Group]="Big"))
That makes it show on only one row:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |