Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two tables, One is the inventory and other is Date table, both are connected via date column.
I want to count no. of Inventory units from Inventory table with a filter on other colum in the inventory table Status.
This is my measure
Solved! Go to Solution.
Hi, @DJKarma
Have you tried using REMOVEFILTERS (DateDimension[Date]) to replace REMOVEFILTERS (DateDimension[Date].[Year]) ?
Best Regards,
Community Support Team _ Eason
@DJKarma , Mark DateDimension as date table and have year column
Inventory Units =
CALCULATE(COUNTA('inventory_master (6)'[Unit]),filter('inventory_master (6)', 'inventory_master (6)'[Status]
IN { "R" ,"I","CB" }) , REMOVEFILTERS (DateDimension[Year])
)
Nope, Its not working, IF i edit the interaction and switch it off on the table where I am using the measure , it works (which was working previously as well), but I want that measure for further calculations where i cant switch off interaction. I want this Measure to be static regardless of any slicer with mentioned filters that is Status
Hi, @DJKarma
Have you tried using REMOVEFILTERS (DateDimension[Date]) to replace REMOVEFILTERS (DateDimension[Date].[Year]) ?
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |