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.
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.
