Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |