Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
crsmith3
Frequent Visitor

Same DAX Calc - diiferent answer: Import v Direct Query

Hi, I have created a market share calculation:

 

Market Share =
DIVIDE (
    SUM ( 'Sales Invoice'[Invoice Amnt (LCY)] ),
    CALCULATE ( SUM ( 'Sales Invoice'[Invoice Amnt (LCY)] ), ALL ( Customer[Customer.Customer] ) )

)

 

This works perfectly in 'Import Mode' but when i recreate the dax in 'DirectQuery' the second part of the dax doesnt work - it returns the sales value for the filtered customer. therefore returns 100% market share.

 

I have check the tick box for 'allow unrestricted measures in directquery mode' but still no luck.

 

Is this a limitation of directquery?

 

Thanks,

 

Chris

 

ps - my table names are slightly different in my warehouse & cube.

 

SnipImage.JPGSnipImage.JPG

 

 

 

 

 

1 ACCEPTED SOLUTION
crsmith3
Frequent Visitor

Used ALLEXCEPT, instead of ALL which gave me the expected results.

View solution in original post

1 REPLY 1
crsmith3
Frequent Visitor

Used ALLEXCEPT, instead of ALL which gave me the expected results.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors