Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi Everyone,
I am bit struggling with the grand totals. Somehow the grand totals are not matching for few rows horizontally but works for others.
Below is the screenshot of the data and the dax code.
The vertical date is a posting date calendar and horizontal is the normal calendar.
The pattern where it does not work is whenever a row contains a Zero/Null value.
Dax code:
VAR prevmonth =
CALCULATE (
[M1] ,
PREVIOUSMONTH ( 'Calendar P'[P Date] )
)
RETURN
CALCULATE (
IF (
ISCROSSFILTERED ( 'Calendar P'[P D] ),
IF (
Max('C P'[P MonthKey]) <= (Max('C'[MonthKey])+100),
[M1] - prevmonth,
BLANK ()
),
CALCULATE (
[M1],
'T1'[Version] = 1
)
)
)
Any help is really appreciated.
Thanks in advance.
@medaxing , force total from rows
VAR prevmonth =
CALCULATE (
[M1] ,
PREVIOUSMONTH ( 'Calendar P'[P Date] )
)
RETURN
CALCULATE (sumx(values(Table[column]), //Column you have used in column(pivot) of matrix
IF (
ISCROSSFILTERED ( 'Calendar P'[P D] ),
IF (
Max('C P'[P MonthKey]) <= (Max('C'[MonthKey])+100),
[M1] - prevmonth,
BLANK ()
),
CALCULATE (
[M1],
'T1'[Version] = 1
)
)))
Refer why grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk
Thanks Amit for the quick response.
No luck though.
I tried to separate the measure as well, still the same issue.
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
65 | |
43 | |
42 |
User | Count |
---|---|
47 | |
38 | |
28 | |
28 | |
27 |