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 power bi community
I am trying to create a calculation to tell me how many people have their names appear 5 or more times in the 'ALPHA-SORT' column, and distinctly-count that individual if they met that criteria (appeared 5 or more times in my report)
This is the calculation I tried, but it didn't calculate the correct people to show when I try to graph the values
my aim is to able to sort individuals by DEPTNAME as a starting point.
Can someone advise what I must have left out in my calculation in order for it to work?
Thanks,
Solved! Go to Solution.
Hi @KeepCalm007
I would use either of these two measures:
5days = CALCULATE ( DISTINCTCOUNT ( Table1[ALPHA_SORT] ), FILTER ( VALUES ( Table1[ALPHA_SORT] ), CALCULATE ( COUNTROWS ( Table1 ) ) > 4 ) )
5days = COUNTROWS ( FILTER ( VALUES ( Table1[ALPHA_SORT] ), CALCULATE ( COUNTROWS ( Table1 ) ) > 4 ) )
These measures filter the values of ALPHA_SORT to those that appear in more than 4 rows.
Regards,
Owen
Hi @KeepCalm007
I would use either of these two measures:
5days = CALCULATE ( DISTINCTCOUNT ( Table1[ALPHA_SORT] ), FILTER ( VALUES ( Table1[ALPHA_SORT] ), CALCULATE ( COUNTROWS ( Table1 ) ) > 4 ) )
5days = COUNTROWS ( FILTER ( VALUES ( Table1[ALPHA_SORT] ), CALCULATE ( COUNTROWS ( Table1 ) ) > 4 ) )
These measures filter the values of ALPHA_SORT to those that appear in more than 4 rows.
Regards,
Owen
@OwenAuger Thank you for your help Owen. I didn't think to use countrows. Are there any resources you can recommend me for improving my formulation of calculations?
Hi,
In the Filter function, replace Table1 with VALUES(Table1[Alphasort])
Does this work?
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 | |
76 | |
63 | |
55 |
User | Count |
---|---|
142 | |
107 | |
89 | |
84 | |
65 |