Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
I have the following measure:
Solved! Go to Solution.
Hi @anandav
I create a measure which show the same result as your Customer subset measure when there is no relationship among tables.
Measure = CALCULATE ( DISTINCTCOUNT ( sales[sale cust] ), FILTER ( ALL ( sales ), sales[sale date] <= MAX ( 'filter date table'[Date] ) && sales[sale date] >= MIN ( 'filter date table'[Date] ) ) )
Also this measure won't change with the slicer from "calendar[date]".
Hi @anandav
I create a measure which show the same result as your Customer subset measure when there is no relationship among tables.
Measure = CALCULATE ( DISTINCTCOUNT ( sales[sale cust] ), FILTER ( ALL ( sales ), sales[sale date] <= MAX ( 'filter date table'[Date] ) && sales[sale date] >= MIN ( 'filter date table'[Date] ) ) )
Also this measure won't change with the slicer from "calendar[date]".
Hi,
It will be a lot easier to help if you share some data, explain the business context and also show the expected result.
Not too sure, but I believe the new REMOVEFILTERS can remove all filters: REMOVEFILTERS ().
Proud to be a Super User!
Paul on Linkedin.
Thanks for the suggestion. But FILTER doesn't accept REMOVEFILTERS()
From DAX.guide:
REMOVEFILTERS is an alias for ALL, but it can be used only as a CALCULATE modifier and not as a table expression like ALL
Can it be done calculate by using cross filter or cross join
CALCULATE(DISTINCTCOUNT(Sales[Sale Cust]), vAG,crossfilter(<>,<>,none))
That doesn't work.
I need a way to remove filters in Sales and Calendar table in the SelectCOlimns statement.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |