Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
14 | |
12 | |
12 | |
9 |