Forum Discussion

hasharma19's avatar
hasharma19
Icon for Helper II rankHelper II
3 years ago

Calculate True and False Output

Dear All, I have an issue wherein i want to count the true and false value. I had creted a measure which is giving me true and False output. It is giving True wherever the rating is compliant and f...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls tru this

count of True = 
VAR _tbl = 
    FILTER(ADDCOLUMNS(VALUES('table'[Site Reviewed]),"Flag", [_COM]),[Flag]=1)
RETURN
COUNTROWS(_tbl)
------
count of False = 
VAR _tbl = 
    FILTER(ADDCOLUMNS(VALUES('table'[Site Reviewed]),"Flag", [_COM]),[Flag]=0)
RETURN
COUNTROWS(_tbl)