Forum Discussion

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
3 years ago
Solved

Count with all Status and Divide by Total

Hi team,   I ahve a column in my dataset named "Status". In Status column we have Completed, In Progress, Awaiting Confirmation and Blanks.    Total Alerts= Sum of counts (Completed+In Progress+...
Need Help
Show and Tell
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    Hi   ghouse_peer 

    try like:

    Ratio =
    VAR _value = CALCULATE(COUNTROWS(TableName), TableName[Status] IN {"Completed", "In Progress"})
    VAR _allvalue = CALCULATE(COUNTROWS(TableName), ALL(TableName))
    RETURN 
    DIVIDE(_value, _allvalue)
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

Hi   ghouse_peer 

try like:

Ratio =
VAR _value = CALCULATE(COUNTROWS(TableName), TableName[Status] IN {"Completed", "In Progress"})
VAR _allvalue = CALCULATE(COUNTROWS(TableName), ALL(TableName))
RETURN 
DIVIDE(_value, _allvalue)
  • ghouse_peer's avatar
    ghouse_peer
    Icon for Post Patron rankPost Patron
    3 years ago

    Thank You it worked...