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

Gustavo_77's avatar
Gustavo_77
Regular Visitor
3 years ago

One approach to this can be to pre-populate all results into one table via UNION with Summarize in it. Shortened version to illustrate syntax. From this dataset, you can filter by the custom column "MeasureType"

ResponseUnion = UNION(
                SUMMARIZE('COF Mat','COF Mat'[Business], "MeasureType", "COF"),
                SUMMARIZE('Data: DPA', 'BusinessKey'[Business], "MeasureType", "DPA")
            )