Forum Discussion
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
- ChandeepChhabraImpactful Individual
- AnonymousNot applicable
- ChandeepChhabraImpactful Individual
Anonymous You are welcome :)
- v-cherch-msftMicrosoft 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