Hoping @amitchandak may be able to help!
I have a card that should reflect a unique count of users in table Facts1. I have a bridgetable 'Region' with 1 to many to Facts1 and Facts 2. Facts2 relates to Facts 1 with 1 to Many Unique ID.
Requirement - Region Slicer should change the user count from Facts1 based on region selected.
I have set up a measure to collect slicer value as well as another to attribute '1' to region selected in Facts 1 and used as visual filter
In table view this works perfectly, so I know formulas/measures are right. However when I switch to card view, the number displayed does not change at all?
What am I missing?
Measure 1:
Hi @Jtischler ,
You can create a measure as below and put this new measure onto the visual to replace the measure [SelRegion] onto the card visual. Please find the details in the attachment.
Measure = SUMX ( VALUES ( 'New Dashboard'[User unique ID] ), [SelRegion] )
Best Regards
User | Count |
---|---|
136 | |
88 | |
65 | |
59 | |
57 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |