Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to Sum a Distinct Count Measure

Hi, I'd like to put a card in my board that tells me how many "Pharmacie" I have : For example here, if I select the 101 secteur, I 'd like to have 10 in my card instead of 0 The Réassort fi...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a measure like

countx(filter(Values('Orders'[Secteur]), [Réassort] >1),[Secteur], blank())

 

or

 

Sumx(filter(Values('Orders'[Secteur]), [Réassort] >1),[Réassort] ,  blank())