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 filter is a measure :  

 

In conclusion I'd like to sum my Réassort measure but I don't know how to do it.

 

Any help !

Thanks

Lydie

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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())