Forum Discussion

ElistheFox's avatar
ElistheFox
New Member
3 years ago
Solved

Create metric with same value based on specific row

Dear PBI community, 

In the picture below, I have a column with sum of total sales for all countries. I would like to add a NEW metric (for example Total Sales of USA) which will have value of United States sales on all rows. Consequently, I would create ANOTHER NEW metric and divide (result will be in %) column Total Sales of USA by column Total Sales. How am I able to achieve it with DAX?

 

Thanks a lot for your help, I have gone through some forum threads but I could not find answer for this specific challenge.

DAX Calculation
metric
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ElistheFox ,

    If so, please create a measure based on the [usa sales].

    measure=maxx(all(Sales Territory),[usa sales])

    If it still does not help, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    3 years ago

    This is such a basic thing to do in DAX that I don't believe you couldn't find it on the forum or even on YT. But nevertheless...

    [USA Sales] =
CALCULATE(
    [Total Sales],
    'Sales Territory'[Sales Territory Country] = "usa"
)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your reply, however, it does not work. If I apply your formula, I will get result only on row with United States. But I need to see the same result on all rows. I´ve even tried to delete all filters but still, no progress.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ElistheFox ,

    If so, please create a measure based on the [usa sales].

    measure=maxx(all(Sales Territory),[usa sales])

    If it still does not help, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.