Measure issue, I get an infinite loading, is it normal ?

[techachuu]

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.

[ray_ux · Accepted 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.