Forum Discussion

Icon for Helper II rank

Helper 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...

Icon for Helper II rank

Helper II

3 years ago

Ahmedx -Thanks a ton for the DAX.
However, ths issue still persist.

The below table i have created with DAX:-

Dist = CALCULATE(COUNTAX(SUMMARIZE('DG Audit Reports','DG Audit Reports'[Site Reviewed],"MaxT", COUNT('DG Audit Reports'[Year])), [MaxT]))

The total supposed to have 42 instead it is giving 40.
Similarly, the DAX you have shared also goving 40 count too.

Can you please relook it. Thanks

Ahmedx
Super User
3 years ago
You need to write another measure like this
count of True Fixed = SUMX(VALUES('Date'[Year]),[count of True ])
- hasharma19
  Helper 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
    Super User
    3 years ago
    
    DAX-Dist Fixed = SUMX(VALUES('Date'[YEAR]),[DAX-Dist ])
- hasharma19
  Helper II
  3 years ago
  Ahmedx -Thank you very much for all the support!
  How i can get rid of future 0.00% values.
  have used 2 measures
  1-_2023 = VAR DEL=CALCULATE([_DECat]/[_HAWBCount],DimDate[ISOYear]=2023)
  RETURN
  IF(ISBLANK(DEl),0,DEl)
  
  for filtering out false
  2-(MAXDate = DimDate[Date]<=MAX (Delivery_Exce[ERDF NC Date])
  - Ahmedx
    Super User
    3 years ago
    I'm not sure I understand you but try to write
    1-_2023 = VAR DEL=CALCULATE(DIVIDE([_DECat],[_HAWBCount]),DimDate[ISOYear]=2023) RETURN IF(ISBLANK(DEl),0,DEl)