Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Measure = single value cannot be determined

Hello, any idea why in single row with one number this issue constantly appear? See picture
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi There,

     

    You should understand the difference between the Measure and Calculated Column. The Calculation you are trying to achieve is more suitable for calculated column and that's why showing an error for the measure calculation.

     

    For measure, You should try SUMX.

     

    measure:=SUMX(list,list[TURNOVER]*5)

     

    Thanks & Regards,

    Bhavesh

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

 

I am not sure "What are DAX" exactly. Do you want to me control of columns name?

 

If it is i renamed column names and now all topic colmn has same name "KONU".

 

So, i editted your code like this;

Konusu1 = lookupvalue(PDFOCR[KONU],PDFOCR[ID],AYS[ID]) 
Check = AYS[KONU]=AYS[Konusu1]

And this is the error.

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi again,

 

I tried your formula with two colmns. First attempt i tried it in one colmn so it did not worked.

 

So two colmns Konusu1 and check method solved my problem.  But i got filter error. Please look that screen capture.

 

Thanks a lot!

 

Edit: There is an filter error i see. In this compare table there is just 21 false record but filter options show grater values in my tables. (203 is my total value in this list.)  

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Is there any solution about wrong counting problem?