Forum Discussion
Post PatronSumx, Cumulative and blank rows
Never had a measure named after me before. Cool. My bad, I meant to use ALL or ALLSELECTED instead of VALUES. With VALUES, every row is in its own Top X. Replace VALUES with ALL and it should work.
Regards,
Pat
Post Patron
Thanks. It works for Total but selects everything instead of (say top 3) in below example.
MaHoneyPat =
VAR topX = [SelectedTopNValue]
RETURN
CALCULATE (
SUM ( 'CPP POS'[Sales Amount] ),
KEEPFILTERS (
TOPN (
topX,
VALUES ( GROWER[CRM_PARENT_GROWER_MASTER_KEY]),
CALCULATE ( SUM ( 'CPP POS'[Sales Amount] ) ), DESC
)
)
)
Thanks,
ritesh
Microsoft EmployeeNever had a measure named after me before. Cool. My bad, I meant to use ALL or ALLSELECTED instead of VALUES. With VALUES, every row is in its own Top X. Replace VALUES with ALL and it should work.
Regards,
Pat
- Ritesh_Air
hahaha. I may have to create a separate folder with all of your solutions. 🙂 Much appreciated.
Thanks. It worked like a charm.
Now if we move on to #3 on my original question, why RANK INR, doesn't respect and gives me all the empty rows instead of stopping at how many values have been selected?
Thanks,
ritesh
- mahoneypat
Did you see my earlier suggestion to wrap your [Rank IR] measure in an IF to compare it against the selected TopN value? Your RankIR measure is not currently set up to limit rows, and will return a result for all rows.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat