Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
Wondering if you could help.
I am trying to create a simple summarized table where it shows where Barclays sits for each category.
in my main table the ranking works using this formula. I have filtered the category to NNIP and it shows that Barclays is ranked 2 based of Vol. (MM).
However when i table showing jus category and the rank it doesn't work.
In this on the allselected didnt work so i tried:
as you can see i have put a visual filter to show Barclays but im getting 3 rather than 2?
Hope this make sense.
thanks
viral
Solved! Go to Solution.
Resolved the issue:
created a measure:
Measure:
var _rank = RANKX(ALL('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC)
VAR _tab =
FILTER (
ADDCOLUMNS (
ALL( 'Dealer Ranking'[Counter Party] ),
"@rank", [Dealer Ranking Number 2 test]
),
[Counter Party] = "Barclays"
)
VAR _rankbarclays =
( MAXX ( _tab, [@rank] )
RETURN
_rankbarclays
Resolved the issue:
created a measure:
Measure:
var _rank = RANKX(ALL('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC)
VAR _tab =
FILTER (
ADDCOLUMNS (
ALL( 'Dealer Ranking'[Counter Party] ),
"@rank", [Dealer Ranking Number 2 test]
),
[Counter Party] = "Barclays"
)
VAR _rankbarclays =
( MAXX ( _tab, [@rank] )
RETURN
_rankbarclays
@ViralPatel212 , Try new new function in the measure
RANK ( desc, ALLSELECTED('Dealer Ranking'[Counter Party]), orderBy([Ranking Size (Vol)]), LAST )
i think you have given the wrong measure here? i tried that and i get a error:
The value for RANK's Ties parameter is invalid. The admissble values are: SKIP, DENSE.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |