Forum Discussion

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

Help with Dax Formula

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: P...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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"
    )
)

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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"
    )
)

 

 

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

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