Forum Discussion

WhiteFox's avatar
WhiteFox
New Member
3 years ago
Solved

Problem with area chart, shows count of rows

  Hello! I had a problem - I need to count total price and total count of people, but every chart area show count of orders (like every row in the table). How can I fix that?
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi WhiteFox 

     

    Please create a measure as suggested:

     

    Then put in the following formula:_

    Distinct count Names = DISTINCTCOUNT(Orders[Names])

    Then on the right side you will find this measure. Please put this measure into a visual

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi WhiteFox 

 

You need to work with measures which you can create under "Modeling" -> "New Measure"

 

For example for the count of employees the right measure could be

 

Distinct count people = DISTINCTCOUNT(Table[People Column])

 

But ti help you more it would be good to see how your table looks like.

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

WhiteFox's avatar
WhiteFox
New Member
3 years ago

That's the table, I don't really understand why area chart shows count of rows:(