Forum Discussion

AShah16's avatar
AShah16
Regular Visitor
5 years ago
Solved

Show Mean, Max and Min value for filtered data in a plot

I have a filtered cross plot. The plot can be filtered by users through several filters and slicers. I want a separate table to display the mean, max and min value ,of the x-axis measure,for the filt...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi AShah16 ,

     

    You can create a summaried table by the x-axis measure. Then calculate value for mean, max and min value. You can try something like below:

     

    Maxvalue = var a =SUMMARIZE(Table,Table[column1],"_measure",[measure]) return MAXX(a,[_measure])

Meanvalue = var a =SUMMARIZE(Table,Table[column1],"_measure",[measure]) return AVERAGEX(a,[_measure])

Minvalue = var a =SUMMARIZE(Table,Table[column1],"_measure",[measure]) return MINX(a,[_measure])

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

AShah16's avatar
AShah16
Regular Visitor
5 years ago

Hi v-deddai1-msft ,

Thanks a lot for your kind reply. In your expression what should i provide as "Table" and "_measure". Somehow when i used the expression it says syntax incorrect for Table.  

 

Thanks