Forum Discussion
filter specific result
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.⚡
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