Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |