Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I have a table with a column Amount and a column Product.
The product is a name and can vary through the months , it's got a lot of values.
I want to make a calculation the SUM of the Amount for every product seperately without
using the Product name explicitly in the DAX code.
I want to do this in the DirectQuery Mode , I am not familyar enought with the restrictions of this mode
Solved! Go to Solution.
Hi @DannyBolier,
You could refer to below formula to create a measure:
Measure = CALCULATE ( SUM ( test[Amount] ), ALLEXCEPT ( test, test[Product] ) )
Regards,
Yuliana Gu
Hi @DannyBolier,
You could refer to below formula to create a measure:
Measure = CALCULATE ( SUM ( test[Amount] ), ALLEXCEPT ( test, test[Product] ) )
Regards,
Yuliana Gu
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.