Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |