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 All,
I am using a switch function to sum up values in a Power BI matrix, but the hierarchy is not rolling up as I expected it to. I am using a switch function to flip between the value I want for France and the values for the rest of countries.
Here is my DAX:
Solved! Go to Solution.
Hi @mf2499pbi
Thanks for reaching out to us.
please try the measures below
Measure = SWITCH(SELECTEDVALUE('Table'[Column1]),"FRANCE",sum('Table'[amount1])/1000, sum('Table'[amount2] )/1000)
TEST = IF(HASONEFILTER('Table'[Column1]),[Measure],SUMX('Table',[Measure]))
then put measure [TEST] into matrix,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @mf2499pbi
Thanks for reaching out to us.
please try the measures below
Measure = SWITCH(SELECTEDVALUE('Table'[Column1]),"FRANCE",sum('Table'[amount1])/1000, sum('Table'[amount2] )/1000)
TEST = IF(HASONEFILTER('Table'[Column1]),[Measure],SUMX('Table',[Measure]))
then put measure [TEST] into matrix,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@mf2499pbi , Try like
Test Rollup =
Sumx(Values(('Hierarchy'[level2] ) , calculate(switch(SELECTEDVALUE('Hierarchy'[level2]), "FRANCE", sum('Table'[Amount1])/1000, sum('Table'[Amount2] )/1000)) ))
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |