topic Re: sum on Distinct value in Dashboards & Analytics Discussions

sum on Distinct value

KHK — Tue, 25 Jul 2023 09:45:18 GMT

Hi,

I am getting 3 values multiple times in a report, i want to calculate sum on distinct values, please let me know how to do.

Re: sum on Distinct value

JoeM — Tue, 25 Jul 2023 13:48:56 GMT

@KHK - Are you grouping on other columns in this insight? Or simply trying to sum up a distance list of a single measure?

Re: sum on Distinct value

KHK — Tue, 25 Jul 2023 14:08:04 GMT

@JoeM In Power Bi Report,they are using in KPI,

Re: sum on Distinct value

KHK — Tue, 25 Jul 2023 14:29:17 GMT

@JoeM actually we are calculating this value for all regions like America, EMEA and etc

Re: sum on Distinct value

RADSr — Tue, 25 Jul 2023 16:40:20 GMT

You may need to provide more information -- it helps when asking questions like this to present the data as well as a mockup of what you want the end result to look like.

I *think* what you want is the sum of the values circled in your pictured list. One way to do that would be to create your list of values in a result set and then use that result set in the insight.

I've added an export which uses Online Store as an example.