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 Team,
Pls help on creating custom row grand total in power BI desktop. Breaking my head for the entire day
Thanks in advance
Solved! Go to Solution.
Hi @Krishnanidar ,
Are you referring to the difference between measure and sum of value?
This is because I am customizing the rule, The Total row shows the synthesis of month 3 or less than or equal
If you want Masure's Total row to display the total value, you can use the following formula:
Measure =
IF(
ISINSCOPE('Table'[Date]),MAX('Table'[Value]),
SUMX(ALL('Table'),[Value])
)
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Krishnanidar ,
Are you referring to the difference between measure and sum of value?
This is because I am customizing the rule, The Total row shows the synthesis of month 3 or less than or equal
If you want Masure's Total row to display the total value, you can use the following formula:
Measure =
IF(
ISINSCOPE('Table'[Date]),MAX('Table'[Value]),
SUMX(ALL('Table'),[Value])
)
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Krishnanidar ,
I created some data:
You mean whether you want to customize the Total row of the table Visual, you can use the IF() and Isinscope() functions to determine whether it is a Total row
IF function (DAX) - DAX | Microsoft Learn
ISINSCOPE function (DAX) - DAX | Microsoft Learn
Custom rules:
The Total row shows the synthesis of month 3 or less than or equal
Here are the steps you can follow:
1. Create measure.
Measure =
IF(
ISINSCOPE('Table'[Date]),MAX('Table'[Value]),
SUMX(
FILTER(ALL('Table'),MONTH('Table'[Date]) <=3),[Value])
)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |