Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |