A single value cannot be determined for a measure

Question

Hello,&nbsp;I'm trying to create a measure, but am getting the "single value cannot be determined" error.&nbsp; I successfully created this a calculated column, but hope to use a measure instead.&nbsp;I'm trying to break out amounts by transaction type.&nbsp; In this example, I want a measure that returns only "forecast" transaction amounts...&nbsp;Forecast =IF ('SALES_TABLE'[TRANSACTION_TYPE] = "FORECAST",'SALES_TABLE'[AMOUNT],0)&nbsp;Breaking out amounts by transaction type would allow me to populate a Power BI table as follows...&nbsp;

jthomson · Answer

Why wouldn't you just put the transaction type as a column in a matrix?

trudgeon · Answer

My example is a simplistic version of what I'm actually needing it for. Just wanted to lay out the goal of a measure in a very basic fashion. The reasons I would like to be able to have "transaction type" measures include...

(1) To use the Actual and Forecast numbers to then calculate Variance and Variance % in a table/matrix format...

(2) To have the ability to create synthetic transaction types without grouping (eg, using Open Orders twice in the same chart)...

v-lili6-msft · Answer

hi,&nbsp;TrudgeonIf you just want to transform your column to measure you could try this formulaMeasure = CALCULATE(SUM(SALES_TABLE[Amount]),FILTER(SALES_TABLE,SALES_TABLE[TRANSACTION_TYPE]="FORECAST"))+0Best Regards,Lin

ashish_mathur · Answer

Hi,
&nbsp;
Drag Customer to the Row labels and Transaction type to the column labels.&nbsp; Write this measure
&nbsp;
=CALCULATE(SUM(Data[Amount]),FILTER(Data,Data[Transaction Type]="Forecast"))
&nbsp;
Hope this helps.

Forum Discussion

A single value cannot be determined for a measure

4 Replies

Related content

Measure = single value cannot be determined

Converting existing simple measure to UDF - cannot determine a single value for column

Single Measure Alert

A Single Value for Column Cannot Be Determined

Help with single value cannot be determined error