Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Oscar
Frequent Visitor

Fields parameter as GroupBy column in SUMMARIZECOLUMNS

Hi,
I created a fields parameter table, and it works just fine when I use the parameter in a matrix visual.
When I try to use the parameter field as a group by column in SUMMERIZECOLUMNS, I get the error 'Column is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.'
Does anyone know how a fields parameter can be used as a group by column in the SUMMERIZECOLUMNS function?
Thanks!

1 REPLY 1
lbendlin
Super User
Super User

Kudos for pushing beyond the boundaries.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.