topic Re: Help with Dax Formula in DAX Commands and Tips

Help with Dax Formula

Chandrashekar — Thu, 12 May 2022 07:37:52 GMT

Hello Team,

Can you please help with Dax formula(Attached PBIX file. I need graph as per screen shot provided in PBIX file

Let me know if it can be achieved in single dax formula.

PBIX: PBIX

Regards,

Chandrashekar B

Re: Help with Dax Formula

Jihwan_Kim — Thu, 12 May 2022 08:24:28 GMT

Hi,

I suggest creating a new table by using the below DAX.

And visualize it by using a culumn chart / aggregating a name column as distinct-count.

Please check the attached pbix file, and the relationship between newtable and sheet2 table is shown.

NewTable = UNION ( SELECTCOLUMNS ( Sheet1, "@Name", Sheet1[Name], "@Condition", Sheet1[Condition1], "@Check", "Condition1" ), SELECTCOLUMNS ( Sheet1, "@Name", Sheet1[Name], "@Condition", Sheet1[Condition2], "@Check", "Condition2" ) )

Re: Help with Dax Formula

Chandrashekar — Thu, 12 May 2022 08:32:52 GMT

Hello,

Thanks for the solution. Is it possible using Dax formula?

Just want to know any other method is there to acheive it.

Regards,

Chandrashekar B