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 UserHi,
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.
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?