Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago
Solved

Dax Help

Hello Team,   How to write DAX to get below result as Column D & E.   Regards, Chandrashekar B
  • ERD's avatar
    ERD
    3 years ago

    For the totals, create 2 more measures like:

    result = 
IF(
	HASONEVALUE('Table'[Si No]),
	[closed],
	SUMX(
		VALUES('Table'[Si No]), [closed])
	)
)
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

Chandrashekar , you can use this measure:

closed =
SWITCH (
    TRUE (),
    NOT ISBLANK ( SELECTEDVALUE ( 'Table'[Date_Closed] ) ), 1,
    NOT ISBLANK ( SELECTEDVALUE ( 'Table'[Date_opened] ) ), BLANK (),
    0
)

Use similar approach for the opened case.

  • Chandrashekar's avatar
    Chandrashekar
    Icon for Resolver III rankResolver III
    3 years ago

    Hello,

     

    Thanks for the reply but am getting total incorrect.

    Regards,

    Chandrashekar B

     

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity Champion
      3 years ago

      For the totals, create 2 more measures like:

      result = 
IF(
	HASONEVALUE('Table'[Si No]),
	[closed],
	SUMX(
		VALUES('Table'[Si No]), [closed])
	)
)
      • Chandrashekar's avatar
        Chandrashekar
        Icon for Resolver III rankResolver III
        3 years ago

        Hello, 

         

        Thank you 🙂

        Regards,

        Chandrashekar B