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,
I have data about roles and programs each role is using. I would like to have a measure or sth that will compare the results.
For example, if Role A is using programs X, Y, Z and Role B is using programs M, X, Y then 66,67% is matching.
Thank you,
Liis
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
I think creating so many measures is not an option for me.. Would there be an easier solution if the data would be modified in some other way?
Hi @Anonymous,
Could you please offer a sample data to have a test and post your desired result if possible?
Regards,
Daniel He
Hi @Anonymous,
Based on my test, you could refer to below steps:
Sample data:
Create a measure:
Measure = DIVIDE(COUNTROWS(VALUES(Table1[B]))-COUNTROWS(EXCEPT(VALUES(Table1[B]),VALUES(Table1[A]))),COUNTROWS('Table1'))Result:
Thank you for your input. But what if I now have 60 roles and if I randomly want to compare two of them, then does it mean I would need to make lots of measures? Basically, one measure per each pair? Would there be an easier method?
Hi @Anonymous,
If your data structure is like the picture I have posted before, I am afraid you need to create multiple measures to meet your requirements.
Regards,
Daniel He
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |