Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to create a measure, but am getting the "single value cannot be determined" error. I successfully created this a calculated column, but hope to use a measure instead.
I'm trying to break out amounts by transaction type. In this example, I want a measure that returns only "forecast" transaction amounts...
Forecast =
IF ('SALES_TABLE'[TRANSACTION_TYPE] = "FORECAST",
'SALES_TABLE'[AMOUNT],
0)
Breaking out amounts by transaction type would allow me to populate a Power BI table as follows...
Hi,
Drag Customer to the Row labels and Transaction type to the column labels. Write this measure
=CALCULATE(SUM(Data[Amount]),FILTER(Data,Data[Transaction Type]="Forecast"))
Hope this helps.
hi, @Trudgeon
If you just want to transform your column to measure you could try this formula
Measure = CALCULATE(SUM(SALES_TABLE[Amount]),FILTER(SALES_TABLE,SALES_TABLE[TRANSACTION_TYPE]="FORECAST"))+0
Best Regards,
Lin
Why wouldn't you just put the transaction type as a column in a matrix?
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)...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |