Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SWITCH function to present one value in whole row

I have SWITCH function like below....   I have function to return EBITA value in case group category is Admin  It works well    Currently the value is assigned to my matrix only in c...
Switch()
SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Anonymous, Can you share the expected output screenshot?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Below you can find expected outcome

    value from admin column should be presented in other columns too (the places with red dot)

     

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      Anonymous, Try this,

       

      Instead of ADMIN_step2_cost centers[Group ] = "ADMIN"   

      Filter( ALL(ADMIN_step2_cost centers[Group ]),ADMIN_step2_cost centers[Group ] = "ADMIN")

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Below code doesn't work (I have the same result - walu only in Admin column) 

        20. Hourly rate - ADMIN = 
CALCULATE([10. EBITA LEVEL (CURR)],All('ADMIN List'),FILTER(ALL('ADMIN_step2_cost centers'[Group ]),'ADMIN_step2_cost centers'[Group ]="Admin"))