Forum Discussion
I have a problem with removefilter
I have this code: Total Receipts Ignoring Amount Filter = CALCULATE( DISTINCTCOUNT(Sales[Чек]), REMOVEFILTERS(Sales[Сума до сплати]), Sales[Сума до сплати] > 0 ) My task is to ...
MattAllington
Community Champion
Community ChampionYou need a dimension table for the column you are trying to remove. You cannot acheive the result you want by using REMOVEFILTER over a fact table.
read my article here for what you should aim for. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/