Forum Discussion
Allexcept and slicer
Hello, guys! I think the solution is not difficult, but I still can't find it. Could you help me? The task - find measure average by filtered date perion in pivot table by each objects (object - ...
Anonymous
https://drive.google.com/file/d/1STDGBeSwvVf6ZUHqHOSFK4TYXmSmDlim/view?usp=sharing
Please share Kudoes and Please mark this as solution
VijayP
Community Champion
Community ChampionAnonymous
Try that measure what you calculate is showing Average by using AVERAGE or AVERAGEX function and then incorporate in my Formula and hope that works! 👍
i use such formula as measure:
SUMX(SUMMARIZE(table_1, object), CALCULATE(AVERAGEX('Calendar', CALCULATE(SUM(value), filter(table_2, category)))))
so, I get Average by columns and sum by rows.
What should I add to this formulla to get average value in every column ?
As I told before CALCULATE ( measure, ALLEXCEPT ( 'Calendar', 'Calendar'[Year] )) works good, but do wrong calculation when using dynamic month filter
Thats the problem