Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Experts
Getting an error on the following measure - cannot work it out.
Solved! Go to Solution.
Escalated = //Try this one
IF (
(VALUE(Complaints[Escalated Complaint]) = 1 || VALUE(Complaints[Escalated Complaint]) = 0)
&& Complaints[Category] = "Compliant",
"Yes",
"No"
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Escalated = //Try this one
IF (
(VALUE(Complaints[Escalated Complaint]) = 1 || VALUE(Complaints[Escalated Complaint]) = 0)
&& Complaints[Category] = "Compliant",
"Yes",
"No"
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Arrrr my column with escalted compliants is a text field not numbers 1 or 0 and i cannot change to whole number
Hi mh still getting the following error Cannot convert value '' of type Text to type Number.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |