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
Hi All,
I am trying to select multiple values from a column to give me either a 1 or 0.
So far I have only got one value as can be seen below:
this is done by using this formula:
Solved! Go to Solution.
@AmarH94 , what values you need
example
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",2,
//add others
0 //Default
)
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",1,
//add others
0 //Default
)
this is the solution that worked for me
@AmarH94 , what values you need
example
Switch(true() ,
'CRT Outbound'[DISPOSITION]= "Dial Error",1,
'CRT Outbound'[DISPOSITION]= "No Answer",2,
//add others
0 //Default
)
Actually this would work, I would just change the 2 to 1 and add other values I need.
Thank you so much this helps a lot!
So example Total Dial would need multiple values such as No Dial and No Answer, so under Total Dial both would have the value 1
@AmarH94 , if the above is not helping
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |