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

Question

this is a screen shot from the tableas you can see there are values missing in the red area which if present will show a meaningful reason for the total at the bottomI 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 appearMeasure = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Net FCF - Unrisked],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED(FactKeyData[Year]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER(FactKeyData[Year], MAX(FactKeyData[Year]), DESC)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;))&nbsp;Any thoughts to fix this?&nbsp;&nbsp;

amitchandak · Accepted Answer

Anonymous , Please use a separate year or Date table and try like
&nbsp;
Measure = CALCULATE([Net FCF - Unrisked],FILTER(ALLSELECTED(Year[Year]),ISONORAFTER(Year[Year], MAX(Year[Year]), DESC)))

Forum Discussion

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

2 Replies

Related content

calculation item from calculation group not working correctly

Measure Calculates Correctly but Repeats Across Every Single TransactionID

Total % not showing correctly

Power BI roundup not calculating correctly

Table not calculating sum correctly