Sum different values from distinctcount

[Anonymous]

It seems to be working in a table but it doesn't work when I use a bar chart. My hypothesis is that each company name is different so it does not understand that all the company names should be summerized when I want to see the weekly amount.

Measures/columns I used:

• Company Names
• Distinctcount of Company names
• Date column (weeks)

Then I used filter level visuals:

• Active Products is 0
•  Terminated products 0>

In powerBi I get a table like the picture below.

[v-juanli-msft]

Hi @Anonymous 

As tested with this data, it seems bar chart also shows well.

Please show me with your bar charts to let me know what difference.

Best Regards
Maggie

[Anonymous]

Thanks for your reply!

When I turn the table into a bar chart, it shows all company names per week with value 1.

When I exclude company name in the axis it doesn't show any values at all.

*EC under value = distinctcount of company name

*Blurred out customer names of course

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Why not adding "Leaving customer" in the "Value" field?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.