tool tip that wont sum

[Anonymous]

Hello,

I am using a waterfall chart for data that looks like this

Company	Sales	Months a Customer
Walmart	100,000	20
Target	100,500	22
Safeway	110,000	28
Winco	150,000	19

What I am trying to do is use months a customer as a tool tip, but its being summed and there is not an option to dont summarize. How can I create a tool tip to accomplish this?

thank you!

[mussaenda]

Hi @Anonymous ,

For the sake of the tooltip,

I used Max or Ave instead of sum so it will still show the correct value

Hope this helps.

[amitchandak]

Tooltip will grouped /aggregated same level as graph/visual

[Anonymous]

@amitchandak  when i hover over walmart in the graph its showing the sum of all the months not Walmarts specific months a customer 

[amitchandak]

@Anonymous ,Can you share screenshot, what is shown and what is expected

[Anonymous]

@amitchandak  PBIX 

hover over one od the companies, then you can see how the months a customer is being summed 

[amitchandak]

When there is no date filter on the chart. And the chart also does not display dates separately. I think it is displaying correctly. Sales value is also added up.

Refer, if tooltip page can help you: https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

[Anonymous]

@amitchandak  hover over safeway in the left chart. 

see how the months a customer tool tip says 56?

It shouldnt be 56 it should be 28

Months a customer should not be summed up 

[Anonymous]

@amitchandak  

i think creating a distinct DAX Measure works here 

= DISTINCT (Table[]months a customer]

[amitchandak]

@Anonymous , Seems like you got the solution, yourself.  Do you need more input?