Hello, I've made this Measure :
Piquetage contrôle à faire Mesure =
Calculate(
DISTINCTCOUNT('Dossiers D2'[Id. GestOT dossier D2]), Filter('Dossiers D2', 'Dossiers D2'[Date contrôle piquetage].[Date] = Blank()), Filter('Dossiers D2', 'Dossiers D2'[Ch. aff. contrôle piquetage] = SelectedValue('Agents étude'[Chargé d'études])))
But when I add it to a table visual, I get an infinite loading, is it normal ? (database is readonly so i can only add measures and calculated columns) Thanks in advance.
Solved! Go to Solution.
@techachuu
Remove the two filters.
Try something like this
Piquetage contrôle à faire Mesure =
Calculate(DistinctCount('Dossiers D2'[Id. GestOT dossier D2]), And('Dossiers D2'[Date contrôle piquetage] = Blank(), 'Dossiers D2'[Ch. aff. contrôle piquetage] = SelectedValue('Agents étude'[Chargé d'études])))
You've nested two filters.
@techachuu
Remove the two filters.
Try something like this
Piquetage contrôle à faire Mesure =
Calculate(DistinctCount('Dossiers D2'[Id. GestOT dossier D2]), And('Dossiers D2'[Date contrôle piquetage] = Blank(), 'Dossiers D2'[Ch. aff. contrôle piquetage] = SelectedValue('Agents étude'[Chargé d'études])))
You've nested two filters.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
240 | |
56 | |
49 | |
45 | |
44 |
User | Count |
---|---|
282 | |
211 | |
82 | |
76 | |
75 |