Convert all Implicit Measures to Explicit SUM measures

[smitpau]

Hi,

The code here for Autogenerate SUM Measures is useful but it requires selected each relevant column in each table.

Is there a way to code it so that it filters the columns for what Power BI has deemed an implicit measure already to avoid having to select columns in the first place.

I'm not familiar with C# code but an idea is that the metadata for the column contains the Summarize by (say SUM) info already so it would use that to create the explicit measure.

Thanks,

Paul

[m-kovalsky]

This post shares a methodology for converting implicit measures to explicit measures. https://www.elegantbi.com/post/reportlevelmeasures