cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prakritnepal-cn
Frequent Visitor

cannot convert value text to type true/false

Hi, 

 

I am trying to use sumx to calculate a total column. I get following error of cannot convert value type: 

prakritnepalcn_0-1626724602128.png

 

My formula used is (on the screenshot as well) : sumx( filter (table1, related (table2'[column with one to many join with table1)]) && bunch of criteria),Table1[balance]) 

 

table relationship screenshot: 

 

prakritnepalcn_1-1626724781976.png

 

How can I modify the formula to go around this error?

 

Thank you for your help

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

@prakritnepal-cn - I have to believe that the error is coming from your RELATED function. I would try removing that to see if it is in fact the issue.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Chilarejo5
New Member

Hi everyone,

 

I am trying to define define an "Implemented state" in a column; where I have to identified if it is "Imported into Production" or "Completed" this must be identified as Implemented:

 

If(OR(modified[Status] = "Imported into Production" , "Completed"),"Implemented","No Implemented")
 
Warning message is showing: Cannot convert value 'Completed' of type text to Type True/False
 
What can I do for fix it?
 
Thanks!
Greg_Deckler
Super User IV
Super User IV

@prakritnepal-cn - I have to believe that the error is coming from your RELATED function. I would try removing that to see if it is in fact the issue.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.