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

30 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    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
      9 years ago

      Oh right, now I realize why I could use this formula before, I totally forgot I used CalculatedColumn. Thanks a lot for reminding me.

    • justalam's avatar
      justalam
      Microsoft Employee
      8 years ago

      I am getting same error here, Pls help.

       

      1 star Count = if(Query1[QID:1109-QoS5pt]="1",1,0)

       

      The column QID contains numbers 1 to 5

    • atillotson's avatar
      atillotson
      Frequent Visitor
      3 years ago

      Hi there,

       

      Having a similar issue but not quite the same. I am trying to make a calculated column, rather than a measure and I get the following error: 

       

      "A single value for column 'Number of Working Days per Year (incl. BH)' in table 'Dim_HR People_CurrentHeads' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

       

      The formula is: 

      Total Working Days per Year (excl. BH) = CALCULATE('Dim_HR People_CurrentHeads'[Number of Working Days per Year (incl. BH)] - Dim_Dates[Total Bank Holidays])
       
      Where Number of Working Days per Year (incl. BH) is a calculated column and Total Bank Holidays is a calculated measure. 
       
      Thanks!
  • rkamiya's avatar
    rkamiya
    New Member
    8 years ago

    Hi there,

     

     

    I am having the same error, but mines about the DIVIDE. Kindly please refer on the formula below.

    Which I had used, Any idea for a fix?

     

    CH_Iteration = DIVIDE('CaseIterations_CH3PH'[CHold_Count], 'CaseIterations_CH3PH'[CHold Validate], 0)

     

    Note that I used the above formula on creating a New Measure. 

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Try this measure

       

      =DIVIDE(SUM('CaseIterations_CH3PH'[CHold_Count]),SUM('CaseIterations_CH3PH'[CHold Validate]),0)

       

      Hope this helps.

       

       

      • rkamiya's avatar
        rkamiya
        New Member
        8 years ago

        thank you so much man! you nailed it right on the spot!! thank you sooooooo much in a million times!!

  • rhemanth's avatar
    rhemanth
    New Member
    7 years ago

    I'm calculating measure sales/sum(sales) in DAX and getting the 'single value cannot be determined' error.

    Sales % of Total = CALCULATE(DIVIDE('table_name'[Sales],SUM('table_name'[Sales]))

    Can anyone help me out in solving this?

     

    Thanks

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Your question is not clear.  Describe your data, show a sample and share the expected result.

      • rhemanth's avatar
        rhemanth
        New Member
        7 years ago
        We have sales column where I want to calculate percentage of sales with the total sales.
        So calculation goes like this: sales/total(sales) * 100
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, I'm also experiencing the same error:

    IF(CONTAINSSTRING( [Manager], Employee[Name] ), true, false)

     

    Anyone has any idea? Many thanks before!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

      Share some data, describe the question and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi everyone,

     

    I have got two tables contents ID and other text columns which named KONU and KONUSU. I releated with ID colums between two tables. ( Many to one and Both Cross Filter Direction)

     

    So i have to compare these two string value columns and by last result i will be get a new column true or false. It's classic and simple as hell as EXACT function in excel but i can not get result any methods of DAX functions in this table. Here what i tried.

     

    EXACT= IF (AYS[KONU] = PDFOCR[KONUSU], "SAME", "Not Same")

    I got this error message in for this code. Same error for this method too, link.

    A single value for column 'KONU' in table 'AYS' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

    Also i have tried measure method. But these colmns Types are Text so measure giving no error or result.

     
    COMPARE = IF ('MEASURES'[AYS Konu] = 'MEASURES'[PDFOCR KONUSU], TRUE(), FALSE() )

     In conclusion, how can i compare and get exact result in Power BI?

     

    Thx a lot,

    Burk.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi, Ashish

         

        My tables looks like it. There is two table like it. One of table OCR table and the other is got by system. I have to compare them. 

         

         

         

  • REIProcess's avatar
    REIProcess
    Regular Visitor
    1 year ago

    Hi

    I am new to Power Bi and hope someone can help

    I have two tables with stock qty's from two different warehouses which I would like to match if they don't match

    I would like to subtract UAE Qty from AU Qty from each warehouse and see the outcome for each separate line in new column comment which I have created. 

    Image below showing my issue 

    Hope someone can give me some help as I am a bit confused with error message 

    Thanks