if i use below measure in table visual then i am getting below error . i am usng direct query
if i remove distinctcount() from measure then it works fine and does not give any error . is there any alternative for implementing this measure to avoid this error?
measure =
Total orders offline =
CALCULATE(DISTINCTCOUNT('ORDERS'[ORDER_NUMBER]),FILTER(PRODUCT,
PRODUCT[CategoryType]="Offline"))
1 ACCEPTED SOLUTION
@powerbiexpert22 , Try using below
Total orders offline =
SUMX(
VALUES('ORDERS'[ORDER_NUMBER]),
IF(
CALCULATE(
COUNTROWS(PRODUCT),
PRODUCT[CategoryType] = "Offline"
) > 0,
1,
0
)
)
Proud to be a Super User! | 
|
@powerbiexpert22 , Try using below
Total orders offline =
SUMX(
VALUES('ORDERS'[ORDER_NUMBER]),
IF(
CALCULATE(
COUNTROWS(PRODUCT),
PRODUCT[CategoryType] = "Offline"
) > 0,
1,
0
)
)
Proud to be a Super User! |
|
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
