Duplicate issue maybe from Dax formula.

[PowerbiNoob23]

Good Morning guys, 

My problem is when I select my slicer to all everything looks fine, but when i Pick a spefic division it doesn't happen to all but 2 of the slicer options give me duplicate values and I think it could be from my dax forumla.

What I am trying to achieve is making my cumulative line stop at the month that it only has data for.

So for my Blue line I have data for all the year.

Purple and grey Don't.

below is a measure that I will in my cumulative measure.

All its saying is if there data make it 1 if not 0. 

I am trying to make the measure for purple and grey not calculate the dates for blue because the line will show for the whole year and not just the first 2 months.

The transtyp column tells me what it is so If I could figure out a way where activatedates doesnt calculate to 1 when <> to spend plan I think that would work.

I really thought my function works but I guess not.

Please let me know if there is anything I can do to help you understand more.

Data can't be shared.

I did make my own calendar table and spend plan column is in the big table.

This is what it looks like when everything is selected.

You won't see the duplicate dots.

[Anonymous]

Hi @PowerbiNoob23 ,

According to your shared screenshots, it seems you are creating a line chart and there are "duplicated" dots there... And the duplicated dots on Nov-22 and Sep-23? Could you please provide the applied fields on Values field of the line chart? If it involves any measure, please share the related formula. It is better if you can share a simplified pbix file with some fake data. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards