Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to Solution.
Used ALLEXCEPT, instead of ALL which gave me the expected results.
Used ALLEXCEPT, instead of ALL which gave me the expected results.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
68 | |
47 | |
39 | |
37 |