Forum Discussion
Ranking in MAtrix
I created rank measure and applied to the matrix with 4 categories the ranking is fine for the first level(customer) and the ranking changes whe i expand the matrix .But in my scenario i just need r...
I worked fine for first level only with customer
when i added another row (year field) it showed me additional 2 data
should we add the year fields to the columns only?
TopN customer =
VAR SelectedTop = SELECTEDVALUE('rankingrange'[rankingrange])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, [Sales(Customer)],
RANKX (
ALLSELECTED( 'Fact'[Customer]),
[Sales(Customer)]
)
<= SelectedTop,
[Sales(Customer)]
)
Sales(Customer) =
CALCULATE(SUM('Fact'[Factored_Turnover_Customer]))