Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Custom Calculation for % Share at each Hierarchy Level

Hi, I have data like this:   Application Show id Netflix The Office 1 Netflix The Office 2 Netflix The Office 3 Netflix The Office 4 Netflix Friends 3 Netflix F...
lbendlin's avatar
lbendlin
Super User
4 years ago

I think your expected result is slightly off. Netflix serves all five IDs.

 

 

 

ID Share = DIVIDE(DISTINCTCOUNT('Table'[id]),CALCULATE(DISTINCTCOUNT('Table'[id]),ALL('Table')),0)

App Share = DIVIDE(DISTINCTCOUNT('Table'[id]),CALCULATE(DISTINCTCOUNT('Table'[id]),REMOVEFILTERS('Table'[Show])),0)