The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[Anonymous]

Hi, i have this problem on my dax measure, can you help me pls? 

Pruebas Horas =

VAR TablaAux =

CALCULATETABLE(

    SUMMARIZE(

        Calendario,

        Calendario[Mes - Año],

        "Horas Hombre", [Horas Hombre]),

        FILTER(Calendario, OR(Calendario[Mes - Año] = "julio 2024", Calendario[Mes - Año] = "agosto 2024") = [PRUEBAHORAS]))

RETURN

TablaAux


Thx!

[Anonymous]

Hi @Anonymous 

Your DAX formula is reporting an error because you are trying to assign a table (containing multiple columns) to a variable that expects a scalar value.

If lbendlin's reply helped you solve your problem, please consider accepting his reply as a solution. If not, could you please provide some dummy data and tell us what you want to get out of this DAX? What are the [Horas Hombre] and [PRUEBAHORAS] measures in this DAX? This will help us to clearly understand your needs and assist you.

Refer to these link:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You are trying to compare a filter to a measure ([PRUEBAHORAS]) ?

Use SUMMARIZECOLUMNS and TREATAS.