Forum Discussion

Arranafc19's avatar
Arranafc19
Helper IV
7 years ago

Creating a Cumulative Line Chart

I am working on a report which calculates the percetage of cars sold per month , with the null value being the ones not sold. I have managed to create the below dataset and calculated the percetages ...
Need Help
Show and Tell
Tips and Tricks
Arranafc19's avatar
Arranafc19
Helper IV
7 years ago

Hi MFelix 

 

Are you able to access it now ?

MFelix's avatar
MFelix
Super User
7 years ago

Hi Arranafc19 ,

 

Try the following measure:

Cumulative % = 
CALCULATE (
    CALCULATE (
        COUNTROWS ( DealerData );
        FILTER (
            ALL ( DealerData[MonthOfSale]; DealerData[Dealer] );
            DealerData[MonthOfSale] <= MAX ( DealerData[MonthOfSale] )
        );
        DealerData[MonthOfSale] <> BLANK ()
    )
)
    / CALCULATE ( COUNTROWS ( DealerData ); ALLSELECTED ( DealerData ) )

Based on the context of your table I had to redo the calculation in the cumulative.

 

Be aware that if you add another field for context like the dealer the formula will give repeated values for each of the months 

 

Check result in PBIX file attach.

 

Regards,

MFelix