Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
It would be realy helpfull if someone can help us with a solution.
Regards
Hello johnt75,
Thank you for your response.
Tried the approach but with this I get a constant value for all countries but that should not be the case here.
Regrads,
Create a Country dimension table like
Country Table = DISTINCT( UNION(
ALLNOBLANKROW('Comp Org'[Country]),
ALLNOBLANKROW('OneForce User'[Country])
))then link that new table to both 'OneForce User' and 'Comp Org', and use the country column from the new table in all visuals
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |