Forum Discussion
Matrix not adding up correctly
Hi everyone! I'm trying to create a matrix visualization in which, depending on the day of the month, will display different measures. On the rows i have item ID (from a sales table) and on the ...
Hi santt66,
You could try to follow below steps:
create a meaurse
day's value = IF ( LASTNONBLANK ( 'calendar'[day], 1 ) <= 15, SUM ( Sheet7[ventas] ), 2 )
monthly value =
SUMX (
FILTER (
ALLSELECTED ( 'calendar' ),
'calendar'[year] = MAX ( 'calendar'[year] )
&& 'calendar'[month] = MAX ( 'calendar'[month] )
),
[day's value]
)modify = IF(HASONEVALUE('calendar'[day]),[day's value],[monthly value])Then use this in Matrix like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi santt66,
You could try to follow below steps:
create a meaurse
day's value = IF ( LASTNONBLANK ( 'calendar'[day], 1 ) <= 15, SUM ( Sheet7[ventas] ), 2 )
monthly value =
SUMX (
FILTER (
ALLSELECTED ( 'calendar' ),
'calendar'[year] = MAX ( 'calendar'[year] )
&& 'calendar'[month] = MAX ( 'calendar'[month] )
),
[day's value]
)
modify = IF(HASONEVALUE('calendar'[day]),[day's value],[monthly value])Then use this in Matrix like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot dax ! That seems to be working just fine :smileyvery-happy: