Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
@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())
User | Count |
---|---|
17 | |
17 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
14 | |
10 | |
8 |