filter specific result

[fab196]

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.

@parry2k 

@amitchandak 

@Anonymous 

@Anonymous

[parry2k · Accepted solution]

@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]

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