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

You need to write another measure like this

count of True Fixed = SUMX(VALUES('Date'[Year]),[count of True ])
hasharma19's avatar
hasharma19
Icon for Helper II rankHelper II
3 years ago

Ahmedx -Thanks!

What changes i should apply to this DAX-Dist = CALCULATE(COUNTAX(SUMMARIZE('DG Audit Reports','DG Audit Reports'[Site Reviewed],"MaxT", COUNT('DG Audit Reports'[Year])), [MaxT]))

so that i can  get the total count of site reviewed is 42
Or please suggest the DAX.
I have 42 site but while applying this dax getting 40.

 



  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

     

    DAX-Dist Fixed = SUMX(VALUES('Date'[YEAR]),[DAX-Dist ])