True/False Expression doesn't specify a column error

[Anonymous]

Hi Everybody,

I'm stuck with a problem that I'm not able to solve.

I got this expression:

 VAR Perf = [VAL2]

        RETURN

        CALCULATE(DISTINCTCOUNT(Sportelli[COD_BANCA]),Performance[COD_AREA]=2,Perf>0.5)

Measure VAL2 is this: 

CALCULATE(SUM(Performance[VAL_NUMERATORE])/SUM(Performance[VAL_DENOMINATORE]))

When i try to load this dax expression i got True/False Expression doesn't specify a column error.

Do you have any hint?

Thanks

[Anonymous]

Hi @mlsx4 , it works, but inthis way i cannot compare data.

i have two tables, banks and performances... banks tables is a dimension table in which i have duplicated values banks according to their multiple branches.

in performance table, the fact one, i have two column, numerator and denominator, that i have summed up in VAL 2 measure.

What i'm trying to do is to count all the banks (not branches) that have val 2 > 50 (or 0.5 if in decimal visual).

so i need to take into account that value.

How can i reach that ?

[mlsx4]

Hi @Anonymous 

I was not trying to make it work with the definite result, but just to check if the problem is with the condition. I suppose you need to do something else, but I cannot figure out how to do it without the structure or data. Can you post some example (with dummy data)?

[mlsx4]

Hi @Anonymous 

 True/False Expression are errors mainly related to CALCULATE function. I think the problem is with the part of: Perf>0.5. But without any knowledge about data or structure is difficult to know. 

What I would do is to split the expressions. I mean try to do 

Measure= CALCULATE(DISTINCTCOUNT(Sportelli[COD_BANCA]),Performance[COD_AREA]=2)

If it works, then the problem is with Perf.