How to aggregate a Measure

[_MG_]

Hey all,

I try to calculate the SUM of a calculated measure aggregated by stores.

For Example:
Stoe          Measure1

A               100

B               150

C               120

Now I want to create a measure which gets 370 as a result. 

I tryed the following way:

test =
VAR tab1 = SUMMARIZECOLUMNS(Store[StoreId], "Measure1", [Measure1])
return
SUMX(tab1, [Measure1])
...but when I'm using the created measure in a visual within PowerBI, the following Error occurs: "summarizecolumns() and addmissingitems() may not be used in this context"

Maybe some of you have an Idea.

Thank you very much!

_MG_

[AlB · Accepted solution]

Hi @_MG_ 

Create another measure based on the one you have:

M2 =
SUMX ( DISTINCT ( Table1[Store]), [Measure1] )

 You can use it on a table visual with Table1[Store] on the rows and you'll get the result for each store plus the sum at the total line. Or you can just use M2 in card visual to get only the total

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[_MG_]

Too easy...
Thank you very much!