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.
I have my data linked to a Date table that I have created. Since I can easily show numbers depending of a Slicer which is nice.
I was able to do a new measure like so :
Association Total - Début = CALCULATE( COUNTROWS(Associations), FILTER( RELATEDTABLE(Association_Application), Association_Application[state] = "AttentePublication" || Association_Application[state] = "GrosseAssociation" || Association_Application[state] = "Publiee" ) )
But now I want the exactly same measure but without the slicer in the game.
I tried with ALL() function but I achieve what I want.
Solved! Go to Solution.
Hey,
create a measure that ignores all the filter coming from your date table like so:
Association Total - Début ignoring the date = CALCULATE( [Association Total - Début] ,ALL('name of your calendar table'[name of the column that is used in the relationship] )
Hopefully this is what you are looking for.
Regards,
Tom
Hey,
create a measure that ignores all the filter coming from your date table like so:
Association Total - Début ignoring the date = CALCULATE( [Association Total - Début] ,ALL('name of your calendar table'[name of the column that is used in the relationship] )
Hopefully this is what you are looking for.
Regards,
Tom
It's working, and thanks for that, but I want to be sure to understand. The slicer put my dashboard in a "time context", but adding ALL() doesn't care of this and overwrite, here, the date range.
That's right ?
Hey,
basically you are right.
CALCULATE(<expression>,<filter1>,...,<filterN>)
allows to modify exisiting filter before the expression is evaluated.
ALL(...) is a filter modifying function that removes an existing filter on a table or column.
Regards,
Tom
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |