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.
Hi
We are currently collecting data on O365 usage via the Graph APIs, from several tenants.
We have 2 reference axes, to find where the user is from his username, sometimes he is in the 2 axes and therefore the 2 foreign keys are filled in.
We seek to put above these 2 repositories a common axis, knowing that the data does not necessarily correspond to the same level on each side, how to consider the thing?
Example:
A axis; Level A; B axis; Level B; Power BI slicer label
USA; 1; America ; 2; UNITED STATES
If we choose united states , let it filter on level 1 of axis A USA , and on level 2 of axis B America.
Knowing that if we try to link the mapping table to the 2 axes one will necessarily be inactive ?
With Dax ? without linking the mapping table ?
and is it possible to map on several levels, for example by states, region after?
Thanks for your help and advice
Hi, @Cobra77
You can try TREATAS function to create virtual relationships in DAX when a relationship does not exist.
Related thread:
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Best Regards,
Community Support Team _ Eason
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |