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.
In my sample data B1,B2, B3 is child level of B, so we don't sum them in the total. However I need to show them in the detail. Please give me some idea
Project | Code | Amount |
101 | A | 100 |
101 | B | 800 |
101 | B1 | 160 |
101 | B2 | 320 |
101 | B3 | 210 |
102 | A | 130 |
102 | B | 800 |
102 | B1 | 270 |
102 | B2 | 260 |
102 | B3 | 560 |
Final Result:
Solved! Go to Solution.
Hi, please try this
measure
SUM =
var select_code = SELECTEDVALUE (Code column)
return if (select_code <> blank(),SUM(Amount),CALCULATE(SUM(Amount), Code column in {"A","B"}))
Hi, please try this
measure
SUM =
var select_code = SELECTEDVALUE (Code column)
return if (select_code <> blank(),SUM(Amount),CALCULATE(SUM(Amount), Code column in {"A","B"}))
Thanks a lot, It works for me
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |