Forum Discussion
Solved
Running Percentages DAX Power BI
Hi all, I'm trying to get running percentages for this dummy dataset based on a real dataset: MemberID, PortfolioID 1,1 1,2 1,3 1,4 1,5 1,6 1,7 1,8 1,9 1,10 2,1 2,2 2,3 I wan...
- Try this:Measure =VAR _group = CALCULATE(max('Table'[MemberID]))VAR _max = CALCULATE(DISTINCTCOUNT ('Table'[PortfolioID]),FILTER(ALLSELECTED('Table'),'Table'[MemberID]=_group))RETURN RANKX(CALCULATETABLE('Table','Table'[MemberID],'Table'[PortfolioID],'Table'[MemberID]=_group),CALCULATE(sum('Table'[PortfolioID])),,ASC)/_max
andhiii079845
Solution Sage
Solution SageTry this:
Measure =
VAR _group = CALCULATE(max('Table'[MemberID]))
VAR _max = CALCULATE(DISTINCTCOUNT ('Table'[PortfolioID]),FILTER(ALLSELECTED('Table'),'Table'[MemberID]=_group))
RETURN RANKX(CALCULATETABLE('Table','Table'[MemberID],'Table'[PortfolioID],'Table'[MemberID]=_group),CALCULATE(sum('Table'[PortfolioID])),,ASC)/_max
It works perfectly. Thank you!