How to get a simple % of a total

[PhilipsNew]

I have a data value in a oracle database

There are 6 choices InProgress, InComplete, waiting, delayed, started and completed

There are 278 in total and the value is want is the % of that total that is either Completed or Started

I want it to display in a visualisation card

I am very new to Power Bi and really appreciate any help, pointers or solutions

Thank You

[danextian · Accepted solution]

Hi @PhilipsNew 

Your measure would probably go like this. Probably, since we don't have a sample data.

DIVIDE (
    --calculate the count where status is either completed or started and show it only when the row is either of the status
    CALCULATE (
        [count measure],
        KEEPFILTERS ( 'table'[status] = "Completed" || 'table'[status] = "Started" )
    ),
    --calculate the count where status is completed or started and apply that to the whole status column
    CALCULATE (
        [count measure],
        FILTER (
            ALL ( 'table'[status] ),
            'table'[status] = "Completed"
                || 'table'[status] = "Started"
        )
    )
)

[Anonymous]

Hi @PhilipsNew ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

[Bibiano_Geraldo · Accepted solution]

Hi @PhilipsNew ,

You can use the following measure:

Completed_Started_Percentage =
VAR TotalRecords = COUNTROWS(TableName)
VAR CompletedOrStarted = 
    COUNTROWS(
        FILTER(
            TableName,
            TableName[Status] IN {"Completed", "Started"}
        )
    )
RETURN
    DIVIDE(CompletedOrStarted, TotalRecords, 0) * 100

Let me know if its ok 

[danextian · Accepted solution]

Hi @PhilipsNew 

Your measure would probably go like this. Probably, since we don't have a sample data.

DIVIDE (
    --calculate the count where status is either completed or started and show it only when the row is either of the status
    CALCULATE (
        [count measure],
        KEEPFILTERS ( 'table'[status] = "Completed" || 'table'[status] = "Started" )
    ),
    --calculate the count where status is completed or started and apply that to the whole status column
    CALCULATE (
        [count measure],
        FILTER (
            ALL ( 'table'[status] ),
            'table'[status] = "Completed"
                || 'table'[status] = "Started"
        )
    )
)

[Ashish_Mathur]

Hi,

Share some dummy data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.