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 me...
  • 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]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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]
)