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 -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's avatar
    Ahmedx
    Icon for Super User rankSuper 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)
    • hasharma19's avatar
      hasharma19
      Icon for Helper II rankHelper II
      3 years ago

      Ahmedx DAX shared by you not working and the furture week (i.e 18, 19, 20...so on ) showing 0.00% whereas there is no data of those weeks in source file.
      Want to show 2022 data from WK01-WK52 and 2023 WK01-WK17 and whereven the future data added same reflect in graph.

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

        Share sample pbix file to help you.