Forum Discussion
filter specific result
HI ,
CAN anyone help me with this problem
my data is listed below
what i want :
if i group the data then, if the gruping column have multiple values then it will return null and if the grouping column have same values then it will make the sum of these values.
| COUNTRY | STATE | VALUES |
| IN | MH | 2 |
| IN | MH | 2 |
| US | MI | 1 |
| US | CA | 3 |
| BZ | SP | 4 |
| BZ | SP | 5 |
for example in my data in the country column "IN " IS COuntry where values are in the values column respec. 2,2 because of the same values it should return sum of these values .
and the next line of country "US" there are multiple values which are 1,3 respec. so it should return null value .
how can we do that using dax?
thanks in advance
please help.
Anonymous
Anonymous
fab196 try this measure
Measure 2 = VAR __values = CALCULATE ( DISTINCTCOUNT( Table3[VALUES] ), ALLEXCEPT ( Table3, Table3[COUNTRY ] ) ) RETURN IF ( __values > 1, BLANK(), SUM ( Table3[VALUES] ) )Instead of BLANK() you can also return 0
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
fab196 try this measure
Measure 2 = VAR __values = CALCULATE ( DISTINCTCOUNT( Table3[VALUES] ), ALLEXCEPT ( Table3, Table3[COUNTRY ] ) ) RETURN IF ( __values > 1, BLANK(), SUM ( Table3[VALUES] ) )Instead of BLANK() you can also return 0
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
how to i get max value for each group of country from multiple values instead of making sum into the if conidtion
IF ( __values > 1, BLANK(), SUM ( Table3[VALUES] )
means how to i replace sum condition with max value for rach group
