Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
hello everyone i have this table
which the ranking is correct
but when i ad time code to the table i get wrong ranking
how can i keep the same ranking as first table even after adding code
here is the measure
Ranking Campaigns By Time =
RANKX(
ALLSELECTED(Campaigns[Campaign Name]),
[Time CTR],
,
DESC,Dense
)
Solved! Go to Solution.
Try
Ranking Campaigns By Time =
CALCULATE (
RANKX ( ALLSELECTED ( Campaigns[Campaign Name] ), [Time CTR],, DESC, DENSE ),
REMOVEFILTERS ( Campaigns[Code] )
)
Try
Ranking Campaigns By Time =
CALCULATE (
RANKX ( ALLSELECTED ( Campaigns[Campaign Name] ), [Time CTR],, DESC, DENSE ),
REMOVEFILTERS ( Campaigns[Code] )
)
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |