Dax Measures

[swarnalvr]

 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

[v-junyant-msft]

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

[Jihwan_Kim · Accepted solution]

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]
)