Forum Discussion

Gaurav51478's avatar
Gaurav51478
Frequent Visitor
4 years ago
Solved

Tableau for to Dax

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
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.