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?
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] )
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.