Plotting calculated Measure after Filtering Table

[Anandakash]

Let say i have a table T with 4 column (a,b,c,d). i create a measure i.e measure = sum(a), filter(T, b =="some value" and c =="some other value"). 
I want to plot measure VS column d (column which doesn't filter the table while calculating measure. I want this plot to be constant but it not coming as constant plot instead this measure is calculated at every different instance  of column d and then plotting it.

Can i have a constant plot???

Thanks,

Akash

[v-yalanwu-msft · Accepted solution]

Hi, @Anandakash ;

Try it.

Measure = CALCULATE(Sum('Table'[Sales]), FILTER(ALL('Table'), 'Table'[Gender] == "M" && 'Table'[Age] < 6))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anandakash]

Thanks, this is what i wanted so i guess plotting x vs y is somehow internally filtering the table containing x. As putting All table as param in the filter condition fixed the issue and returned us the desired output.

[v-yalanwu-msft]

Hi, @Anandakash ;

Try it.

Measure = CALCULATE(Sum('Table'[Sales]), FILTER('Table', 'Table'[Gender] == "M" && 'Table'[Age] < 6))

I don't quite understand what you mean, it would be better if you could share the results you wish to output.

The final show:

Or

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anandakash]

I just want value of this measure to be independent( I.e constant plot of Measure Vs Country) of Country since for calculating measure i have not filtered table on the basis of this column(Country)

[Anandakash]

@amitchandak ( i see you as top Kudoed Author)  is this achievable?? Will really appreciate if you can help here

[Anandakash]

let My Table =

Sales	Age	Gender	Country
11	3	M	B
19	4	F	C
15	3	F	A
14	6	F	B
27	8	M	C
12	2	M	A

And

Measure = CALCULATE(Sum('Table'[Sales]), FILTER('Table', 'Table'[Gender] == "M" && 'Table'[Age] < 6))

See the plot between measure and column Country isn't constant and Instead it is calculating the measure for Country Column instances "A", "B", "C" and then plotting it. 
I want this plot to be constant for "A", "B", "C". Is this Achievable???

[VijayP]

@Anandakash Question is incomplete! it is better share some sample data with a snap shot of out come