topic Re: Dax Measures in DAX Commands and Tips

Dax Measures

swarnalvr — Sun, 02 Mar 2025 09:18:23 GMT

If(

Selectedvalue(sales[country]) = 'US',

Calculate(

Selectedvalue(sales[weight]) * Sales[Total Market],all excep(account, account[accountid],

All(asset)

Sales[Total Market]

)

Dax measure not working, help required

Re: Dax Measures

Jihwan_Kim — Sun, 02 Mar 2025 11:20:07 GMT

Hi,

I am not sure how your semantic model looks like or how your expected outcome looks like, but please try something like below whether it provides the expected result.

measurename: = IF ( SELECTEDVALUE ( sales[country] ) = 'US', CALCULATE ( SELECTEDVALUE ( sales[weight] ) * Sales[Total Market], ALLEXCEPT ( account, account[accountid] ), ALL ( asset ) ), Sales[Total Market] )

Re: Dax Measures

Anonymous — Tue, 04 Mar 2025 01:52:54 GMT

Hi swarnalvr ,

Agree with Jihwan_Kim!
Please provide sample data of all tables involved in DAX, the relationship between tables and your expected results according to the following post:
Re: How to Get Your Question Answered Quickly - Page 2 - Microsoft Fabric Community
It is difficult for us to understand what effect you want to achieve and where the problem lies with only DAX. Thank you for your cooperation!

Best Regards,
Dino Tao