Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Need Help DAX
Need Help DAX measure
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

 

UK sum and others avg : =
IF (
HASONEVALUE ( Countries[Country] ),
SWITCH (
SELECTEDVALUE ( Countries[Country] ),
"UK", SUM ( Data[Value] ),
AVERAGE ( Data[Value] )
)
)

 

 

Link to the sample pbix file 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Jihwan_Kim  thnaks for valuable time in looking into this issue.

      i dint understand your question.

       

      country will be linked to state and state will be linked to city.

      when we expand the country in matrix, there will be states appear in that case our DAX measure we wrote for country how it will be impact the state level data in the same matrix?