Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - Segregate within groups based on coefficient and sum subsets

Hello everyone, 

 

I am trying to do the following in dax and I need some help.

 

First of all, I have a table with several groups and a value for each snapshot date within a range.

There is also a coefficient (%) for each value.

 

             Team1                Team2           Team 3           Measure

Jan 1     100 (10%)         200 (35%)       300 (65%)       500

Jan 2     50  (24%)          60 (45%)         400 (15%)       60

Jan 3     30  (60%)          100 (23%)       500 (45%)       530

Jan 4     400 (35%)          20  (75%)       10 (34%)         430

 

What I am trying to do is to sum the values for all teams but only when the coefficient is >= 25%.

For example, on Jan 2, the measure should equal 60 points because there is only 1 value where the coefficient was >25%.

 

EDIT: I should have mentioned that the cofficient is calculated at the team level. This is my challenge, I need to calculcate the coefficient at the team level FIRST. And SECOND, refer to this coefficient in my "sumif" formula.

 

Thank you so much !

 

Jason.

4 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee

    Hi Anonymous

     

    Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. If not, please share more details about your issue so that we could help further on it.

     

    Regards,

    Cherie