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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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