Forum Discussion
tool tip that wont sum
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 ...
hover over one od the companies, then you can see how the months a customer is being summed
amitchandak
Super User
Super UserWhen 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
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
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?