Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I'm struggling to convert the Include LOD in Power BI. I'm not getting the result required.
Tableau Query is
{ INCLUDE [Number (Sheet11)],[Name (Sheet11)],[Organization (Sheet11)],[Distribution (Sheet11)],[Division (Sheet11)]:
COUNTD(IF [Status (Sheet11)] = "Pass"
THEN [Number of Records]
END)}
Number of Records = 1
The result coming in Tableau is
The query I kept in power BI
I am not sure where I'm wrong. But the result in tableau and Power BI are totally different
How should we convert Include LOD in Power BI DAX
I have attached my Tableau and Power BI Fie as reference.
Help in this is really needed.
Thanks in advance.
Solved! Go to Solution.
Hi @asdf1608
Try the following DAX
Calculation2 =
CALCULATE(
DISTINCTCOUNT('Sheet1'[Number ]),
FILTER(
ALLEXCEPT(
'Sheet1',
'Sheet1'[Number ],
'Sheet1'[ Name],
'Sheet1'[Organization],
'Sheet1'[Distribution],
'Sheet1'[Division]
),
'Sheet1'[Status] = "Pass"
)
)
This is the result you want
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @asdf1608
Try the following DAX
Calculation2 =
CALCULATE(
DISTINCTCOUNT('Sheet1'[Number ]),
FILTER(
ALLEXCEPT(
'Sheet1',
'Sheet1'[Number ],
'Sheet1'[ Name],
'Sheet1'[Organization],
'Sheet1'[Distribution],
'Sheet1'[Division]
),
'Sheet1'[Status] = "Pass"
)
)
This is the result you want
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.