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

Question

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?

tahreem24 · Answer

geekmachine811&nbsp; try something like below:

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

themistoklis · Answer

geekmachine811&nbsp;
What is your filter that you aretrying to apply?
&nbsp;
You have the following statement which is incompete
FILTER(Sheet1,Sheet1[Attribute])
&nbsp;
It should be something like :
FILTER(Sheet1,Sheet1[Attribute] = "6M to 3M") but this will only show values for this attribute only

geekmachine811 · Answer

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

themistoklis · Answer

geekmachine811&nbsp;
&nbsp;
Can you send a snapshot of the table that you are trying to achieve?

geekmachine811 · Answer

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'.&nbsp;So basically I would like my formula to be 'Count of&nbsp; Agenda from Table2/Table1[Value]'&nbsp;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 toSummary Activity.&nbsp;My Filter however has to&nbsp; be on Table1[Attribute]

Forum Discussion

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

6 Replies

Related content

Convert True False and Count - DAX Help

True/False, if statement

DAX Involving TRUE/FALSE Column

Cannot Convert value of type text to type true false

True/False Measure