Forum Discussion
Missing value in Matrix visual although the the total is calculated correctly
this is a screen shot from the table as you can see there are values missing in the red area which if present will show a meaningful reason for the total at the bottom I am thinking it has to...
Anonymous , Please use a separate year or Date table and try like
Measure = CALCULATE(
[Net FCF - Unrisked],
FILTER(
ALLSELECTED(Year[Year]),
ISONORAFTER(Year[Year], MAX(Year[Year]), DESC)
))
amitchandak
Super User
Super UserAnonymous , Please use a separate year or Date table and try like
Measure = CALCULATE(
[Net FCF - Unrisked],
FILTER(
ALLSELECTED(Year[Year]),
ISONORAFTER(Year[Year], MAX(Year[Year]), DESC)
))
yup that worked 🙂