Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create summarize table with if statement

Hello everyone, I'm creating a scorecard with two main features.  The first is a table with overall KPIs.  This has been straight forward to create. What I would like to do is populate a table with...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous ,

    >>However I get a multiple column error.

    Unfortunately, power bi not support this.

    AFAIK, if statement not support to return table or multiple columns as expressions result. In addition, Power bi not support to create dynamic calculated column/table based on filter/slicer.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

>>However I get a multiple column error.

Unfortunately, power bi not support this.

AFAIK, if statement not support to return table or multiple columns as expressions result. In addition, Power bi not support to create dynamic calculated column/table based on filter/slicer.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Good to know.  The best work around I can think of is to use the button-bookmark approach where I stack a bunch of detailed tables on top of each other and only display the one based on the button they select.

     

    Not as elegant of a solution than what I wanted but it's the best I can do.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Did you end up coming up with a solution? I am facing this right now.