Cannot Convert Value '' of type Text to type True/False

[geekmachine811]

Hello, I am facing a rather frustrating issue. I want to return the count of values based on a filter and i keep on getting the erorr as per my subject. My measure is a s below:

Agenda Count = CALCULATE(COUNT('Retention Activities Master List'[Agenda]),FILTER(Sheet1,Sheet1[Attribute]))

Above is an example of data from table 'Sheet1'.
The 'Retention Activities ....' Table field [Agenda] is of type Text.

Any workaround?

[v-eqin-msft]

Hi @geekmachine811 ,

Sorry for that the information you have provided is not making the problem clear to me.🤔

Could you please provide me with more details about your table and expected output or share me with your pbix file from your Onedrive for Business after removing sensitive data?

Best Regards,
Eyelyn Qin

[themistoklis]

@geekmachine811 

What is your filter that you aretrying to apply?

You have the following statement which is incompete

FILTER(Sheet1,Sheet1[Attribute])

It should be something like :

FILTER(Sheet1,Sheet1[Attribute] = "6M to 3M") but this will only show values for this attribute only

[geekmachine811]

Exactly, I want it to be dynamic because I have several fields in place

[themistoklis]

@geekmachine811 

Can you send a snapshot of the table that you are trying to achieve?

[geekmachine811]

So basically, I have a Benchmark table(Table1) that contains certain values based on a Parameter (Summary Activity).

Each member(on a separate table 'Table2') needs to be benchmarked against the table above based on the count of 'Summary Activities'. 

So basically I would like my formula to be 'Count of  Agenda from Table2/Table1[Value]'

Note: Theres an existing relationship between Table 1 and Table 2.

Table 2 contains the names of each member plus the 'Agenda'. Agenda in this case is similar to

Summary Activity.

My Filter however has to  be on Table1[Attribute]

[Tahreem24]

@geekmachine811  try something like below:

Measure = CALCULATE(COUNT(Tbl2[Agend]),FILTER(Tbl2,HASONEFILTER(Tbl2[Attribute])))