Forum Discussion

Resolver III

2 years ago

Solved

Dax Help

Hello Team, How to write DAX to get below result as Column D & E. Regards, Chandrashekar B

2 years ago

For the totals, create 2 more measures like:

result = 
IF(
	HASONEVALUE('Table'[Si No]),
	[closed],
	SUMX(
		VALUES('Table'[Si No]), [closed])
	)
)

Community Champion

2 years ago

For the totals, create 2 more measures like:

result = 
IF(
	HASONEVALUE('Table'[Si No]),
	[closed],
	SUMX(
		VALUES('Table'[Si No]), [closed])
	)
)

Resolver III

2 years ago

Hello,

Thank you 🙂

Regards,

Chandrashekar B