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, however, at the time of creating the measure, this results in 100% in each row, which is incorrect. In the following image, I show the syntaxys that I put to the extent that it is NOT working for me:

%ACC TURBINES PLANNED = CALCULATE([% OF TURBINES PLANNED], FILTER(ALLEXCEPT('PREVENTIVES','PREVENTIVES'[Parque eolico ]), 'PREVENTIVES'[Fecha]<= MAX('PREVENTIVES'[Fecha])))

What I look for the accumulated to give me as a result is the following:

I hope you can apyarme, THANK YOU!

1 Reply

  • 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())