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.
Hello Experts,
I have a situation where I need to calculate UNIQUE NUMBER OF ENGAGED USERS.
In my data model people can:
All of these activities are in diffrenet tables as follwoing image:
What I need is to calculate that number of unique numbers who were engaged. It means they have sumbited an idea / commented / liked.
If I filter on 1 idea I want to see if the somebody who sumbited and idea and at the same time liked and commented was calculated only once.
Please see following example for selection on IDEA = 1
Number of engaged users should be only 3. You can see eventhougt user A has been interacted 3 times he counts only 1 time.
I was thinking to somehow virually union all 3 tables together and then run DISTINCTCOUNT. But still it has to follow the filter context.
Thanks for your help
Cheers!
Martin-Prague
HI @Martin-Prague ,
Unfortunate, current dax formula not support auto calculate related table fields.
I'd like to suggest you create a bridge table to link and merge these tables fields and use id to manually summary and calculate on these tables.
Optimizing Many-to-Many Calculations in DAX with SUMMARIZE and Cross Table Filtering
Regards,
Xiaoxin Sheng
Thanks all, at the end I build a view in SQL that combines my data into one table and then I am able to do this calculation simply in Power BI.
Any ideas?
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |