Comparing Two Columns in a Line Graph

[dmykins]

I am looking to have two lines on my line graph, one showing total entries each week over a period of time, the other line would show manufacturers entered over the same period. 

My data looks like this:

Region	Channel	# of Entries Gained	Week Entered	Manufacturer	Month Entered
West	Trade	1	1	Bradford White	June
East	Distribution	1	1	No Purchase	June

This type of data goes through the month of August currently. 

I can graph it to look like this:

This is correct in it shows the total entries in blue and total (cumulative) manufacturer entries in purple.
Ideally I want that purple line to show whichever manufacturer I select, while the blue line remains the same. 

I filtered by manufacturer, but it effects both lines in the graph.

Any help is appreciated! 

[VahidDM]

Hi @dmykins 

Try to use REMOVEFILTERS or ALL DAX codes to avoid filtering the " # of Entries Gained" by manufacturer.

Something like these:

No. of Entries Gained = calculate (sum(table[# of Entries Gained]),REMOVEFILTER(table[Manufacturer]))

OR

No. of Entries Gained = calculate (sum(table[# of Entries Gained]),ALL('table')

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[dmykins]

Unfortunately, it has not. I will upload a screenshot of how the data is set up, but I only have the one table, so maybe that is why? I messed around with trying to get REMOVEFILTER to work, but to no avail. 

[v-easonf-msft]

Hi, @dmykins 

Can you show the formula you are currently using for the new measure based on the field [#of Entries Gain]?

Best Regards,
Community Support Team _ Eason

[dmykins]

Good Morning!

 I copied and pasted both of the suggested formulas, and messed around with them a bit, unfortunately, they still filtered so I started to just mess with it on my own and ended up with this: 

Total Entries REMOVEFILTERS() = CALCULATE(SUM('Individual Entries'[# of Entries Gained]))

Again, it calculates the total fine, but doesn't ignore the filter. 

[VahidDM]

@dmykins 

Try this measure:

No. of Entries Gained = calculate (sum(SUM('Individual Entries'[# of Entries Gained]),REMOVEFILTER('Individual Entries'[Manufacturer]))

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[dmykins]

No. of Entries Gained = calculate (sum(SUM('Individual Entries'[# of Entries Gained]),REMOVEFILTER('Individual Entries'[Manufacturer]))

)

When adding that in the formula, it is all basically underlined in red with warnings saying parameter is no the proper type, removefilter is not a function.