Forum Discussion
Solved
Calculate average based on same category
Hi Everyone, Good day! As per the below snapshot I want to create a new measure where the marked percentage numbers should get averaged beacuse it lies under the same category of column A but colum...
SUMESHKUMAR22 Try:
Measure =
VAR __a = SELECTCOLUMNS('Table'[a])
VAR __Result =
AVERAGEX(
SUMMARIZE(FILTER(ALL('Table'),[a] IN __a),[a],[b], "__T_margin%",[T_margin%]),
[__T_margin%]
)
RETURN
__Result
Hi Greg_Deckler ,
Thanks for prompt response!
The final total avergae should come up 48.70% instead of 49.56% . As we will not consider the repetitve percentage values as per the Table[a] disitnct values.Hi Greg_Deckler , Anonymous
Below is the total average (Result), I'm expecting in your above measure.
The blank that is coming shouldn't come up and give the total result as 48.70% .
Thanks in advance!
