Distinct count dax with a measure filter

v-xjiin-msft

Thank you for your response.

It works great with showing the distribution number in a card visual.

However, if I want to calculate the distribution % of the total number of stores

how can I achieve this?

For instance, I edited the Edit Interaction to show below distribution and this is great.

In below, I would like to calculate the following.

• Brand distribution for each team. (=373/1569=23.77%)
• SKU distribution in a number of stores in the region (38/49=77.55%)

However, I am having a difficulty because I only changed the edit interaction so

the measure itself calculates a different number, so the distribution percentage comes out wrong.

Updated sample data

If you could help with this, it would be a tremendous help.

Many thanks,

H