Based on one of the EDNA courses, I have made a profit and loss account with a template. Everything is working fine except one thing. For some customers, not all topics are applicable.
So if a customers does not have for example Exploitatiekosten, it should not be shown.
Is there a way to hide these rows?
So for example, these rows in yellow should not be shown as they have no values:
This is the DAX formula I use to get the values in:
Annual Totals =
‘Metric Selection’[Metric Selected] = “Bedragen”, 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”) ,
I have tried to add a filter to this table with “Annual Totals <> blank”, but this is not working.
It would be great if somebody can help me!
Best regards, Marieke