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 all,
i hope someone could help me with my problem. I created a new measure like the following....
Opportunity | Total Count Product Groups (based on opportunity products) | |
A | 1 | |
B | 4 | |
C | 2 | |
D | 6 | |
E | 2 | |
F | 1 | |
G | 4 | |
H | 4 | |
Result should be | ||
Count opportunity products with different equal Product groups | ||
2 Opportunities with 2 different PG | ||
3 Opportunities with 4 different PG | ||
1 Opportunity with 6 different PG | ||
etc...... |
Solved! Go to Solution.
You can use this to get the count of those with 2, for example.
Opps with 2 = COUNTROWS(FILTER(DISTINCT(Table[Opportunity]), [Total Count Product Groups] = 2))
To get a table with all the counts, you can make a calculated table of numbers called "Count" with GENERATESERIES(1, 10, 1) for example and use that in a visual, and then use SELECTEDVALUE(Counts[Value]) in place of 2 above.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat,
thanks it works!
Thanks for your support!
Hi @Levo_242 ,
Could you please mark the helpful post as Answered since your problem has been resolved? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
You can use this to get the count of those with 2, for example.
Opps with 2 = COUNTROWS(FILTER(DISTINCT(Table[Opportunity]), [Total Count Product Groups] = 2))
To get a table with all the counts, you can make a calculated table of numbers called "Count" with GENERATESERIES(1, 10, 1) for example and use that in a visual, and then use SELECTEDVALUE(Counts[Value]) in place of 2 above.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |