Calculated Measure percent of total

[Anonymous]

Hello community, 

This may be easy, but I do not know how to create a calculcated measure to get the percentage of 'Transported' from my Transported Boolean column.

I would like to have a graph where I can show the % transported, as below, but not show the percentage not transported. In the end I would like to have a bar chart showing the % transported, and a line showing the total number of transports per month. This is what I have so far: 

My data looks like this: 

Incident Number	Date	Transported Boolean
A	Nov 2019	Transported
B	Nov 2019	Not Transported
C	Nov 2019	Transported
D	Dec 2019	Transported
E	Dec 2019	Not Transported
F	Dec 2019	Transported

I really appreciate any and all help with this! 

Kind regards, 

Denisse

[Fowmy]

@Anonymous 

The formula I shared will work to give you the count if you slice it by incident number as well. It is a matter of how you visualize it, try to put on a matrix and check.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Fowmy]

@Anonymous 

Add the following two measures, you can use a line and clustered column chart  visualize

% Transported = 
DIVIDE(
    CALCULATE(
        COUNTROWS(Table5),
        Table5[Transported Boolean] = "Transported"
    ),
    COUNTROWS(Table5)
)

Transported Count = 
    CALCULATE(
        COUNTROWS(Table5),
        Table5[Transported Boolean] = "Transported"
    )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy Hello, 

Thank you for this, it is working well. Would you know how to add the factor of my incident number sometimes having duplicates? The count of transports is slightly higher, and I would like it to count the number of transports for each distinct incident number.