Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Create Cumulative Measure from a Created Measure

Hello I am stuck trying to create a MEASURE that tells me the ACCUMULADO, of percentages (measure created) in relation to maintenance that will be done to some wind turbines on planned dates, ho...
amitchandak's avatar
amitchandak
Super User
3 years ago

Syndicate_Admin , refer how to use power bi window function for that

Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs

 

 

or

 

Cumm Sales = Divide( CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date]))),CALCULATE(SUM(Sales[Sales Amount]), all())

 

Cumm Sales = Divide( CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date]))),CALCULATE(SUM(Sales[Sales Amount]), allselected())