Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Percentage between two columns

Good day,    I have two tables, related to each other by fist column (name of the source file). I'm looking for measure to show me how many "RISK and HIGH RISK" checks were done comparing to "none ...
heed help
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

Anonymous,

 

Try these measures:

 

Check Count = COUNT ( CheckReason[SOURSE FILE NAME] )

Check Percent = 
VAR vNumerator =
    CALCULATE (
        [Check Count],
        CheckReason[REASON FOR CHECK] IN { "risk", "high risk" }
    )
VAR vDenominator = [Check Count]
VAR vResult =
    DIVIDE ( vNumerator, vDenominator )
RETURN
    vResult