Forum Discussion

baluk's avatar
baluk
Frequent Visitor
7 years ago

Tableau LOD "Include" In powerbi dax

Tableau LOD "Include" In powerbi dax:

 

{include [AcctID (Custom SQL Query)] : Max([TotalPhonenumbers])}

 

I have tried the below DAX 

Phonessss=
SUMX (
VALUES (Info[AcctID]),
CALCULATE ( MAX(Infos[TotalPhonenumbers]) )
)
But its not work.................

 

Need help to convert above calculation in PowerBI (Dax).

Thanks in Advance........

Need Help

2 Replies

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    7 years ago

    Hi baluk 

    If you want to take the maximum value of Infos[TotalPhonenumbers] per value of Info[AcctID] and then sum them, then your DAX expression looks correct to me.

     

    This is the same result you would get with your Tableau INCLUDE expression if you use a SUM aggregation.

     

    Using dummy data, I was able to get the same results using expressions equivalent to yours in Tableau & Power BI.

     

    But if your results are not as expected, could you post a sample of your data and the result you would expect to get? A sample PBIX would be useful if possible.

     

    Regards,

    Owen

    • baluk's avatar
      baluk
      Frequent Visitor
      7 years ago

      Hi

      According to my data, the Tableau "INCLUDE" LOD expression is removing the duplicates.

      for example, the expected result is 10000 according to PowerBI but as per the Tableau it will remove duplicates and it will project remain.

       

      If I work with sample data what I was projected in the previous Dax was absolutely correct.

       

      OwenAuger  thanks for your reply.