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

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

        Ahmedx Is there any emaill addess, will share through onedrive.

        file size is bit high