topic Re: Measure = single value cannot be determined in Desktop

Measure = single value cannot be determined

Anonymous — Tue, 06 Sep 2016 10:44:39 GMT

Hello, any idea why in single row with one number this issue constantly appear? See picture

Re: Measure = single value cannot be determined

BhaveshPatel — Tue, 06 Sep 2016 10:49:18 GMT

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

Re: Measure = single value cannot be determined

Anonymous — Tue, 06 Sep 2016 10:59:03 GMT

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

Re: Measure = single value cannot be determined

rkamiya — Fri, 11 May 2018 22:39:55 GMT

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.

Re: Measure = single value cannot be determined

Ashish_Mathur — Fri, 11 May 2018 23:59:18 GMT

Hi,

Try this measure

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

Hope this helps.

Re: Measure = single value cannot be determined

rkamiya — Sat, 12 May 2018 13:18:08 GMT

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

Re: Measure = single value cannot be determined

Ashish_Mathur — Sun, 13 May 2018 00:13:56 GMT

You are welcome. If my reply helped, please mark it as Answer.

Re: Measure = single value cannot be determined

justalam — Mon, 06 Aug 2018 09:18:35 GMT

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

Re: Measure = single value cannot be determined

Ashish_Mathur — Mon, 06 Aug 2018 09:21:11 GMT

Hi,

Try this

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

Re: Measure = single value cannot be determined

justalam — Mon, 06 Aug 2018 09:47:02 GMT

Re: Measure = single value cannot be determined

Ashish_Mathur — Mon, 06 Aug 2018 09:49:20 GMT

Hi,

That formula should be written as a calculated column formula (not as a measure). If it still does not work, then describe the question, share some data and also show the expected result.

Re: Measure = single value cannot be determined

justalam — Mon, 06 Aug 2018 10:40:25 GMT

I added that as a column and it worked, Thanks :)

Re: Measure = single value cannot be determined

rhemanth — Wed, 10 Oct 2018 02:38:35 GMT

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

Re: Measure = single value cannot be determined

Ashish_Mathur — Wed, 10 Oct 2018 23:15:25 GMT

Hi,

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

Re: Measure = single value cannot be determined

rhemanth — Thu, 11 Oct 2018 05:16:05 GMT

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

Re: Measure = single value cannot be determined

Ashish_Mathur — Fri, 12 Oct 2018 03:34:36 GMT

Hi,

The solution will depend upon what you drag to the row labels section of your visual.

Re: Measure = single value cannot be determined

Anonymous — Fri, 08 Jul 2022 10:03:11 GMT

Hi, I'm also experiencing the same error:

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

Anyone has any idea? Many thanks before!

Re: Measure = single value cannot be determined

Ashish_Mathur — Sat, 09 Jul 2022 02:16:48 GMT

Hi,

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

Re: Measure = single value cannot be determined

Anonymous — Mon, 11 Jul 2022 19:11:52 GMT

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.

Re: Measure = single value cannot be determined

Ashish_Mathur — Tue, 12 Jul 2022 01:47:41 GMT

Hi,

Share some data and show the expected result.