Hide rows with no values from template P&L

DAX DAX Calculations
8

Hi @marieke,

Thanks for providing a sample PBIX :+1:

Annual Totals = 
SWITCH( TRUE(),
    'Metric Selection'[Metric Selected] = "Bedragen", IF( FORMAT([Selected Year Actuals],"€#,0") ="", BLANK(), FORMAT([Selected Year Actuals],"€#,0")),
    'Metric Selection'[Metric Selected] = "Percentage tov omzet", [Selected Year Actuals %],
    'Metric Selection'[Metric Selected] = "Index tov vorig jaar", FORMAT([Actuals Index],"0"),
    0
)

The issue is caused by the FORMAT() function. When that returns a ‘blank’ it is actually returning an empty text string. So I added an IF statement checking for that “” and then returning a BLANK instead that resolves the issue.

I hope this is helpful.

2 Likes