Forum Discussion
PowerBI Matrix how to hide blank rows
Hi, I have a data model that looks like this: Sales are linked to Stores by a LocationKey, also Sales are linked to RSA by an RSAKey. I need to create a matrix that shows Stores, then RSA,...
The visual i am using is something like this:
Sales$ = CALCULATE(SUM(HomeStore[Sales]),DateMaster[FiscalYear] = YEAR(TODAY()))
Does the additional year filter affect it?
(To clarify, the LocationKey coming from Location table, RSACode coming from RSA table, not the Sales table. it works automatically if both of them come from the Sales table)