Forum Discussion
Plotting calculated Measure after Filtering Table
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
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.
7 Replies
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.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.
Anandakash Question is incomplete! it is better share some sample data with a snap shot of out come
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???amitchandak ( i see you as top Kudoed Author) is this achievable?? Will really appreciate if you can help here
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.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)
