Forum Discussion
Solved
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...
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.
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!