Forum Discussion

Frequent Visitor

5 years ago

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

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 = C...

Frequent Visitor

5 years ago

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

Icon for Community Champion rank

Community Champion

5 years ago

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

geekmachine811
Frequent Visitor
5 years ago
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]