Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem with SWITCH formula

Hello   I try to write a SWITCH formula but it does not offer to autocomplete the table and column of my table when I enter the first parameter in the formula. It says: A single value for column ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , the formula you may have try with filter CALCULATE(COUNT(DifferentTable[Col1]),filter(DifferentTable,DifferentTable[Col2]=RELATED(SameTable[Col1])))

 

If switch is ised in a measure you have use insure single value like in given example

Switch( True(),
Max(Table[column]) = "19/20-P13", [Overdue]
Max(Table[column]) = "20/21-P1" ,[Overdue]*0.9
Max(Table[column]) = "20/21-P2" ,[Overdue]*0.8
Max(Table[column]) = "20/21-P3" ,[Overdue]*0.7
Max(Table[column]) = "20/21-P4" ,[Overdue]*0.6
Max(Table[column]) = "20/21-P5" ,[Overdue]*0.5
Max(Table[column]) = "20/21-P6" ,[Overdue]*0.4
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

     

    Thanks but I get this error:

    The column 'SameTable[Col1]' either doesn't exist or doesn't have a relationship to any table available in the current context.

     

    Any solution? 

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous , it will work from 1-M direction. So change filter Table and related column

      Try like

      CALCULATE(COUNT(DifferentTable[Col1]),filter(SameTable,SameTable[Col1]=RELATED(DifferentTable[Col2])))