Forum Discussion
How to aggregate a Measure
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_
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.
2 Replies
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.
Too easy...
Thank you very much!
