I am having one table where having formual based value at Country,state,district and village level. All are created as a hierarchy in tabular model, when I use this model in power bi and drag the value and country, it shows the sum of value (state+district+village) at country level, since all this value is formula based at every level so can not sum it. So how I can show the country level value when we drag country , when I drill , it should show the state and its corresponig value,not the sum of its child value.
... View more