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

Icon for Community Champion rank

Community Champion

5 years ago

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
Frequent Visitor
5 years ago
Exactly, I want it to be dynamic because I have several fields in place
- Tahreem24
  Super User
  5 years ago
  geekmachine811 try something like below:
  
  Measure = CALCULATE(COUNT(Tbl2[Agend]),FILTER(Tbl2,HASONEFILTER(Tbl2[Attribute])))
- themistoklis
  Community Champion
  5 years ago
  geekmachine811
  
  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]

Related content