Forum Discussion

UditJ's avatar
UditJ
Icon for Helper III rankHelper III
3 years ago

To convert Tableau Calculation to Power BI DAX

How to write below calculations from tableau in DAX:-

1. COUNT(IF[is DQ] =1 AND [Resolved] =0 THEN 1 END)

2. [Placements with Open Errors] /  MAX({FIXED [User]:COUNTD([Pcode])})

3.  IIF([Show Ignored Errors]="True",[Ignored Errors],NULL)

Amy suggestions ? 

1 Reply

  • UditJ I hope this help's you!

    1. COUNT(IF[is DQ] =1 AND [Resolved] =0 THEN 1 END)
    CNT =
    VAR X = IF(AND([is DQ] =1,[Resolved] =0),1)
    RETURN
    COUNTX('Table Name',X)

    #############################################################
    2. [Placements with Open Errors] /  MAX({FIXED [User]:COUNTD([Pcode])})
    DvD = DIVIDE([Placements with Open Errors] ,MAX({FIXED [User]:COUNTD([Pcode])}))

    If this not work Please explain MAX({FIXED [User]:COUNTD([Pcode])}) formula.

    #############################################################

    3.  IIF([Show Ignored Errors]="True",[Ignored Errors],NULL)

     

    IIFS = IF([Show Ignored Errors]="True",[Ignored Errors],NULL)


     

     

    UditJ THANK YOU!!