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 su...
Jihwan_Kim
Super User
Super User
UK sum and others avg : =
IF (
HASONEVALUE ( Countries[Country] ),
SWITCH (
SELECTEDVALUE ( Countries[Country] ),
"UK", SUM ( Data[Value] ),
AVERAGE ( Data[Value] )
)
)
will this work if i add more sub categories in the matrix?