cannot convert value of type text to type true/false

[Anonymous]

I am trying to count the number of rows in table Process_FCO by filter the companyname in table Companies.  I am getting the error "cannot convert value of type text to type true/false".  I can not figure out how to correct this.

Number of Change Orders=

CALCULATE(

COUNT(Process_FCO[instanceid]),

FILTER(

Companies,Companies[companyname]))

[Anonymous]

@nilimarodrigues There is no relationship between FCO & Companies because there is no Company ID within FCO but there is ID in Commitments and both FCO and Commitments is tied to Project via Project_ID

[v-jingzhang]

@Anonymous The relationships seem good. You could use Selectedvalue() to get the company value and use it in a measure like:

Number of Change Orders = 
VAR company = SELECTEDVALUE(Companies[CompanyName])
RETURN
CALCULATE(COUNT(Process_FCO[InstanceId]),Companies[CompanyName] = company)

I use some sample data to replicate the tables and relationships and it works. Please refer to this PBIX file.

Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[nilimarodrigues]

Hello,

Is there any relationship between company table and process_FCO table? For example if they have One to Many relationship, if you simply pull the "ID" column and take summarization as "COUNT" - it will give you the count of all process IDs for selected company name. 

If there is no relationship, would you be able to share some PBIX file or sample records of tables to understand the question further? 

Thanks

[Anonymous]

@AlB I am using a slicer that is pulling companyname

[AlB]

Hi @Anonymous 

What is the condition for the filter? Are you looking for a specific company name?  You are just using the column

Companies[companyname] in the second argument of FILTER()

Number of Change Orders =
CALCULATE (
    COUNT ( Process_FCO[instanceid] ),
    FILTER ( Companies, Companies[companyname] = "Name of company here" )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers