Percent of grand total doesn't adjust dynamically even though interaction filter is activated

[Mo-Ba]

Hello all, 

I'd like to visualize interactively / dynamically the percentage ratio of a number of interviewees as shown in the figure below. At the same time, I'm visualizing the corresponding absolute number of interviewees (filtered dynamically) together with the grand total (dynamic filter is inactivated). 

Even though the absolute number on top changes dynamically, the percentage field doesn't. I wonder why the dynamic filter doesn't work for the percentage field, even though it is activated. Basically, the percentage field is the same field as the fitered absolute number on top with identical settings. The only adjustment I did was to show the value as percent of grand total (see picture below, though shown in German).

Can anyone help me to find the problem here?

Many thanks in advance!

[Anonymous]

Hi @Mo-Ba ,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@Mo-Ba , % of grand total from the menu is based on allselected. So once you filter, It might become 100%.

Calculate a measure  like

divide([Measure], calculate([Measure],all(Table)))