Sum of Distinct Count

[bhartsell]

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?

[ankitpatira]

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

[Greg_Deckler]

I am thinking:

SUMX(DISTINCT([Outlet]),[Circulation])

https://msdn.microsoft.com/en-us/library/ee634943.aspx

https://msdn.microsoft.com/en-us/library/ee634959.aspx