Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a matrix using the following measure to rank [Location]. I am unable to figure out the syntax to use ALLNOBLANKROW or another method for removing the blank values when counting the rows.
Rank =
Rankx(ALLSELECTED(Table[Location]),CALCULATE(COUNTROWS(
GROUPBY(Table[Sample ID],Table[Order Choice Type])),
DATESINPERIOD('Calendar'[DATE],EOMONTH(TODAY(),-1),-12,MONTH)))
Any help is appreciated.
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |