Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.