Forum Discussion
Summarize function error: the expression refers to multiple columns
Hi Anonymous ,
Irwan has explained very clearly why this error is reported and given a solution. If you want to get the summarized values group by the data, you can also create a table visual in Power BI directly with below setttings to get it:
Hi Canguru ,
You can refer the following link to insert a pivot table to get it just as shown in below screenshot:
Power Pivot Principles: Introducing the SUMMARIZE Function
Best Regards
Thanks Irwan ,
How did you return a virtual table using the summarize expression? I have created the measure using PowerPivot. How can I create the virtual table in PowerPivot?
Hi Anonymous ,
Irwan has explained very clearly why this error is reported and given a solution. If you want to get the summarized values group by the data, you can also create a table visual in Power BI directly with below setttings to get it:
Hi Canguru ,
You can refer the following link to insert a pivot table to get it just as shown in below screenshot:
Power Pivot Principles: Introducing the SUMMARIZE Function
Best Regards