Forum Discussion
Solved
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 d...
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.
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???