Forum Discussion

Luis_Caston's avatar
Luis_Caston
Helper III
1 year ago
Solved

The True/False expression does not specify a column.

Dear all, I've a problem with this formula and I don´t know why. Formula: FORMAT(CALCULATE([Peso Neto Salidas], ALL(Cliente[Alias Cliente]), ALL(LineasSalidas[Alias - Marca]), MAX(Calendario[...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Luis_Caston ,

     

    Thanks elitesmitpatel for the quick reply. I have some other thoughts to add:

    Peso Neto Salidas Año Fiscal -1 = 
var _a= CALCULATE([Peso Neto Salidas], FILTER(ALL('Calendario'),[AñoFiscal]=SELECTEDVALUE('Calendario'[AñoFiscal])-1)) 
 RETURN FORMAT(_a,"#,0,") & " kg total"

    Best Regards,

    Neeko Tang

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

elitesmitpatel's avatar
elitesmitpatel
Solution Supplier
1 year ago

Hey Luis_Caston 

The issue with your formula is related to how MAX(Calendario[AñoFiscal])-1 is used inside the FORMAT function. The error occurs because MAX(Calendario[AñoFiscal])-1 may not be handled correctly when passed into functions like FORMAT without proper context.

Try this Measure:--

VAR PreviousFiscalYear = MAX(Calendario[AñoFiscal]) - 1

RETURN
FORMAT(
CALCULATE(
[Peso Neto Salidas],
ALL(Cliente[Alias Cliente]),
ALL(LineasSalidas[Alias - Marca]),
PreviousFiscalYear
),
"#,0,"
) & " kg total"

If it helps Kudos the work and Accept it as Solution.

  • Luis_Caston's avatar
    Luis_Caston
    Helper III
    1 year ago

    Hi elitesmitpatel 

    Thank you for your support!
    Same error. I've change your approach avoiding the FORMAT but idem, the same error:

    VAR PreviousFiscalYear = MAX(Calendario[AñoFiscal]) - 1

    RETURN

    CALCULATE(
    [Peso Neto Salidas],
    ALL(Cliente[Alias Cliente]),
    ALL(LineasSalidas[Alias - Marca]),
    PreviousFiscalYear
    )