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.
Hello,
I created a measure with a filter on a table.
However, I would like to add another filter from another table.
Here is my measurement and I would like to add another filter in the measurement.
CALCULATE(DISTINCTCOUNT('Dossiers Traités/Equipe'[NumeroDossier]);FILTER('Dossiers Traités/Equipe';'Dossiers Traités/Equipe'[EquTRAIT] = "Voiture" || 'Dossiers Traités/Equipe'[EquTrait] = "Moto" || 'Dossiers Traités/Equipe'[EquTrait] = "Velo" || 'Dossiers Traités/Equipe'[EquTrait] = "Bateau"))
I want add this filter :
Filter('Dossiers Clos'; 'Dossiers Clos'[Libelle] = "Voiture"
I tried, related table, if, ... But I still have errors in the formulas
why add a filter to this extent and not a simple filter on the visualization ? The reason is simple, thaks to these measures, I will be able to make other calculations.
Thank you
Solved! Go to Solution.
CALCULATE can use implict filters
CALCULATE( Expression, [Filter 1]; [Filter 2]; ... )
So remove the explicit FILTER function:
MeasureName = CALCULATE ( DISTINCTCOUNT ( 'Dossiers Traités-Equipe'[NumeroDossier] ), OR ( 'Dossiers Traités-Equipe'[EquTRAIT] = "Voiture", OR ( 'Dossiers Traités-Equipe'[EquTrait] = "Moto", OR ( 'Dossiers Traités-Equipe'[EquTrait] = "Velo", 'Dossiers Traités-Equipe'[EquTrait] = "Bateau" ) ) ) )
And you can add the new filter as another parameter (each parameter acts with an implicit AND)
MeasureName = CALCULATE ( DISTINCTCOUNT ( 'Dossiers Traités/Equipe'[NumeroDossier] ); OR ( 'Dossiers Traités/Equipe'[EquTRAIT] = "Voiture"; OR ( 'Dossiers Traités/Equipe'[EquTrait] = "Moto"; OR ( 'Dossiers Traités/Equipe'[EquTrait] = "Velo"; 'Dossiers Traités/Equipe'[EquTrait] = "Bateau" ) ) ); 'Dossiers Clos'[Libelle] = "Voiture")
Hope this helps
David
Can you post some sample data so that this issue can be recreated?
CALCULATE can use implict filters
CALCULATE( Expression, [Filter 1]; [Filter 2]; ... )
So remove the explicit FILTER function:
MeasureName = CALCULATE ( DISTINCTCOUNT ( 'Dossiers Traités-Equipe'[NumeroDossier] ), OR ( 'Dossiers Traités-Equipe'[EquTRAIT] = "Voiture", OR ( 'Dossiers Traités-Equipe'[EquTrait] = "Moto", OR ( 'Dossiers Traités-Equipe'[EquTrait] = "Velo", 'Dossiers Traités-Equipe'[EquTrait] = "Bateau" ) ) ) )
And you can add the new filter as another parameter (each parameter acts with an implicit AND)
MeasureName = CALCULATE ( DISTINCTCOUNT ( 'Dossiers Traités/Equipe'[NumeroDossier] ); OR ( 'Dossiers Traités/Equipe'[EquTRAIT] = "Voiture"; OR ( 'Dossiers Traités/Equipe'[EquTrait] = "Moto"; OR ( 'Dossiers Traités/Equipe'[EquTrait] = "Velo"; 'Dossiers Traités/Equipe'[EquTrait] = "Bateau" ) ) ); 'Dossiers Clos'[Libelle] = "Voiture")
Hope this helps
David
Sorry for the late response but with jet lag ... 🙂
Hello,
I just tested the formula it works.
I didn't know that we didn'tt have to filter with Calculate.
Thanks for the information and the solution.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |