Missing value in Matrix visual although the the total is calculated correctly

[Anonymous]

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 do with the measure I am using which I have copied from excel and not sure if what changes to apply to make those missing values appear

Measure = CALCULATE(

                              [Net FCF - Unrisked],

                      FILTER(

                                       ALLSELECTED(FactKeyData[Year]),

                                      ISONORAFTER(FactKeyData[Year], MAX(FactKeyData[Year]), DESC)

                         ))

Any thoughts to fix this?

[amitchandak · Accepted solution]

@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)
))

[Anonymous]

yup that worked 🙂