Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ranking Issues

1.Hi Folks, I am using  source is tabular cube. How we build the cube we are calling all facts in view(Main FactTable) and connect with Dimenssions. Now my view producing 800000(8 lakhs) records so w...
Need Help
Tips and Tricks
v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Here is rank created by measure and column:

Rank(Measure) = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Value])),,ASC,Dense)
Rank(Measure) = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Value])),,ASC,Dense)

The result shows:

See my attached pbix file.

 

Best Regards,

Giotto