Forum Discussion

swarnalvr's avatar
swarnalvr
Frequent Visitor
1 year ago
Solved

Dax Measures

 

 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

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

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

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

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