The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Everyone
This Dax works fine for DESC order, but it not working when I used ASC order, Rank start with 2 .
most propably some names have blank values therefore are ranked "1". Try with VALUES instead of ALL.
If it didn't wokr try
FILTER ( VALUES ( Provider[Name] ), [Actual Value] <> BLANK () )
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |