Error in unpivot DAX query

It looks like you are trying to create a table using a measure. 
Use this code to create a new table and then you can create the visual you are looking for.

DowntimeTable = 
UNION(
        SELECTCOLUMNS('H1_daily',"Total losses","Equipment failure loss", "Down time", 'H1_daily'[Equipment failure loss]),
        SELECTCOLUMNS('H1_daily',"Total Losses","Setup & adjustment loss","Down time", 'H1_daily'[Setup & Adjustment loss])
    )

Hey Vish_korg ,

If you are trying to build a DAX Table then the solution provided by jgeddes  should be ok.

On the other hand, if you aleready have the initial table in Power Query, why not UNPIVOT it there and simplify your DAX code?!?

Here is the M code to do it in PQ:

// This query processes a table containing equipment failure and setup adjustment loss data, 
// adds a custom column, unpivots the data, changes the data type of the downtime column, and removes an extra column.
// Developed by Cristian Angyal with Custom Chat GPT "Power Query Wizard"

let
    // Create initial table from compressed JSON data
    SourceTable = Table.FromRows(
        Json.Document(
            Binary.Decompress(
                Binary.FromText("i45WMjJQ0lEyNFCK1YlWMgaxTcFMQ1Mg0wLCBImaKcXGAgA=", BinaryEncoding.Base64), 
                Compression.Deflate
            )
        ), 
        let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Equipment failure loss" = _t, #"Setup & adjustment loss" = _t]
    ),

    // Add a custom column with a static value of 1 --- could be ANY value
    AddCustomColumn = Table.AddColumn(SourceTable, "Custom", each 1),

    // Unpivot all columns except the "Custom" column
    UnpivotedData = Table.UnpivotOtherColumns(AddCustomColumn, {"Custom"}, "Total Losses", "Down Time"),

    // Change the data type of the "DownTime" column to Int64
    ChangedType = Table.TransformColumnTypes(UnpivotedData, {{"Down Time", Int64.Type}}),

    // Remove the "Custom" column
    RemoveCustomColumn = Table.RemoveColumns(ChangedType, {"Custom"})

in
    // Output the final table
    RemoveCustomColumn

Hope it helps.

If this answer was helpful, please consider accepting it as the solution to help the other members find it more quickly.

Kudos appreciated also 😉

Cheers,

Cristian Angyal
LinkedIn  |  X (Twitter) |   Romania Power BI User Group  |  YouTube