Forum Discussion
Tableau LOD "Include" In powerbi dax
Super UserHi 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
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.