Forum Discussion
Dynamic total with sum and average
Dear All,
i am using a Matric in Power BI desktop and i have data like below
I know how to dynamically manipulate the grand total as average.
but here i need total column of Uk with sum and other rows with average.
could you please help me out with logic?
refer to this link for more.
https://docs.google.com/spreadsheets/d/1ZJz1XlfpGcnBzaiC070lAfJpjy2_1VhRcj541EcHNSo/edit?usp=sharing
amitchandak Pragati11
5 Replies
- Jihwan_Kim
Super User
UK sum and others avg : =
IF (
HASONEVALUE ( Countries[Country] ),
SWITCH (
SELECTEDVALUE ( Countries[Country] ),
"UK", SUM ( Data[Value] ),
AVERAGE ( Data[Value] )
)
)Jihwan_Kim i mean what if i have states, cities and county level drill down fields in the matrix? the same measure will work for the low granularity level values?
- Jihwan_Kim
Hi,
Thank you for your feedback.
Can you share your sample pbix file? I think it depends on how your model looks like, and also it depends on how the countries - states - cities are related.
