Forum Discussion

Anandakash's avatar
Anandakash
Microsoft Employee
4 years ago
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...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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's avatar
    Anandakash
    Microsoft Employee
    4 years ago

    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)