Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |