Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We are developing HR dashboard and have 2 columns in table "Promotion" and "Promotion to Leadership". Since this is promotion table, value for Promotion = Yes in all rows but "Promotion to Leadership" = Yes or No. I want to combine them for legend so that Legend will show values as Promotions and Promotions to Leadership separately in line chart.
Please help with DAX.
Solved! Go to Solution.
Thanks for reply Amit.
That looks like another way but I found if clause syntax and tried it -
@lokeshb31 , You need to have a table (say flag) with values yes and no, Join both columns with this. One join will be inactive. That you can activate using userelationship
Thanks for reply Amit.
That looks like another way but I found if clause syntax and tried it -
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |