Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum different values from distinctcount

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-juanli-msft
        Community Support
        7 years ago

        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.