Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

True/False Expression doesn't specify a column error

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
Need Help
Tips and Tricks

3 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      mlsx4
      Memorable Member
      2 years ago

      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)?