Tableau for to Dax

[Gaurav51478]

Hello Everyone

I am doing tableau migration to Power BI, So i am converting one single form from tableau code to dax

Tableau Formula:
(COUNTD(IF ([Sales Type]="AS" AND [Type]="Subs") THEN [Ord Nbr] ELSE NULL END))+
SUM(IF ([Sales Type]="PS" AND [Type]="Subs") THEN [Qty] ELSE 0 END)

I have tried this  below dax

DAX

If(Table[Type]="Subs" && WW_Subscription5[SALES_TYPE]="APOS",DISTINCTCOUNT(WW_Subscription5[ORD_NBR]),BLANK())

+

If(WW_Subscription5[Type]="Subs" & WW_Subscription5[SALES_TYPE]="POS",Sum([Qty]),0)

Please help

[Anonymous]

Hi @Gaurav51478 ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Gaurav51478 ,

Please have a try.

Column =
VAR _COUNTD =
    CALCULATE (
        DISTINCTCOUNT ( 'TABLENAME'[ORD_NBR] ),
        FILTER (
            'TABLENAME',
            'TABLENAME'[Type] = "Subs"
                && 'TABLENAME'[SALES_TYPE] = "APOS"
        )
    )
VAR RESULT =
    CALCULATE (
        SUM ( 'TABLENAME'[QTY] ),
        FILTER (
            'TABLENAME',
            'TABLENAME'[Type] = "Subs" & 'TABLENAME'[SALES_TYPE] = "POS"
        )
    )
RETURN
    _COUNT + RESULT

If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

What issue did you encounter when you tried it?

Note:  Probably a bad idea to try and add NULL and a number - both in Tableau and Power BI.