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: PBIX 

 

Regards,

Chandrashekar B

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

     

     

2 Replies

  • 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