Solved: Re: Default Aggregation on a Column

Hoping · ‎07-18-2023

If a dataset has a default summarisation on a column, will removing it and making it "Do not Summarize" affect the SUM or COUNT on a visual ?

Ritaf1983 · ‎07-18-2023

Hi @Hoping if you moving it from data view is switching off all default agregations, but you can manipulate it from visuals as I showed you in the previous discussion (just select the aggregation you need or "don't summarize") :

https://community.fabric.microsoft.com/t5/Desktop/Disable-Aggregation-on-Columns-during-Personalisat...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎07-18-2023

Hi @Hoping if you moving it from data view is switching off all default agregations, but you can manipulate it from visuals as I showed you in the previous discussion (just select the aggregation you need or "don't summarize") :

https://community.fabric.microsoft.com/t5/Desktop/Disable-Aggregation-on-Columns-during-Personalisat...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile