Cumulative count with percent in Y-axis

[CR]

Hi,

I have 2 measures for cumulative lines, one for the ACTUAL, one the FORECAST

Cumul Actual = 
CALCULATE (COUNT(MASTER[Document Reference]);
    FILTER(ALLSELECTED('MASTER');'MASTER'[Date]<=MAX('MASTER'[Date]));
    FILTER(ALLSELECTED('MASTER');'MASTER'[Status Date]="Issued"))

Cumul Forecast = 
CALCULATE (COUNT(MASTER[Document Reference]);
    FILTER(ALLSELECTED('MASTER');'MASTER'[Date]<=MAX('MASTER'[Date]));
    FILTER(ALLSELECTED('MASTER');'MASTER'[Status Date]="Forecast"))

And t works fine when I display them in a visual:

But I need to display the % in the Y axis.

Note: pencent is the sum of ACTUAL and FORECAST.

Anybody knows how it could be set up ?

Thanks in advance because I'm lost.

Regards,

CR

[v-lili6-msft]

hi, @CR 

Do you mean that add a new measure

measure=[Cumul Actual] / [Cumul Forecast]

and then drag it into visual?

If so, [Cumul Actual] and [Cumul Forecast] value is so big but percent value will be very small, It will looks like this:

I suggest you use Line and Column Mixed chart, drag percent value as a column value.

If not your case, please share some sample data with the expected output.

Best Regards,

Lin

[parry2k]

@CR what you mean by sum, isn't the % is actual divided by forecast?

[CR]

Indeed @parry2k but I don't know how to update correctly the measure and / or how to use it in the visual... 

[CR · Accepted solution]

solved!

I've created additional measures to better understand what I need:

One measure cumuating the values Issued 

Cumul Issued = 
CALCULATE (COUNT(MASTER[Document Reference]);
    FILTER(ALLSELECTED('MASTER');'MASTER'[Engineering Progress]="Issued");
    FILTER(ALLSELECTED('MASTER');'MASTER'[Date]<=MAX('MASTER'[Date])))

One measure cumulating the values Issued and Not Issued (Forecast) (<> "")

Cumul Issued + Forecast = 
CALCULATE (COUNT(MASTER[Document Reference]);
    FILTER(ALLSELECTED('MASTER');'MASTER'[Engineering Progress]<>"");
    FILTER(ALLSELECTED('MASTER');'MASTER'[Date]<=MAX('MASTER'[Date])))

One measure counting all the references (100%)

Cumul - ALL = 
CALCULATE (COUNT(MASTER[Document Reference]);
    FILTER(ALLSELECTED('MASTER');'MASTER'[Engineering Progress]<>""))

Then, I created 2 main measures.

One measure cumulating the issued + forecast as percentage

Cumul issued + forecast = [Cumul issued + forecast]/[Cumul - ALL]

One measure cumulating the issued as percentage

Cumul issued = [Cumul issued]/[Cumul - ALL]

Then:

- I applied the format Percentage to these 2 main measures

- I put these 2 main measures in the visual

- I actived the option Show Secondary (Y-axis block)

Regards,

CR