Sum of Distinct Count

Question

Not sure if this is the right place to ask. I'm having trouble figuring out how to do something on Power BI online.

I have two columns, the "Circulation," which is numeric, and "Outlet," which is text. The circulation for each "Outlet" value will be the same every time, ie is "The Times" is the Outlet, its circulation will be 2,000 every time. Is there a way to find the sum of all Circulations for distinct Outlets, so I'm not double counting?

greg_deckler · Answer

I am thinking:&nbsp;SUMX(DISTINCT([Outlet]),[Circulation])https://msdn.microsoft.com/en-us/library/ee634943.aspxhttps://msdn.microsoft.com/en-us/library/ee634959.aspx

ankitpatira · Answer

bhartsell&nbsp;In powerbi.com maybe use Matrix visual and see if it groups by Outlet and gives you what you're after.

Forum Discussion

Sum of Distinct Count

2 Replies

Related content

count distinct

Distinct Count

Sum Distinct Count

SUM of Count of Distinct Values

DAX Calculation for Distinct Count