Forum Discussion
I have a problem with removefilter
I have this code:
Total Receipts Ignoring Amount Filter =
Total Receipts Ignoring Amount Filter =
CALCULATE(
DISTINCTCOUNT(Sales[Чек]),
REMOVEFILTERS(Sales[Сума до сплати]),
Sales[Сума до сплати] > 0
)
My task is to create a measure that will not react to the cutoff by [Сума до сплати]. But this measure still reacts to this cutoff. How can this be fixed?
My task is to create a measure that will not react to the cutoff by [Сума до сплати]. But this measure still reacts to this cutoff. How can this be fixed?
2 Replies
- MattAllington
Community Champion
You 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/
sjoerdvnSolution Sage
If it is not linked to a dimension table (see previous comment), try using ALL instead of REMOVEFILTERS.
