Dynamic summary table based on table visual data

[bhargavanand]

Hi,

I have a report with 4 main tables, Date table and 6 bridge tables. I have created a new table called "MeasureTable" with 'Name' column from one of the bridge tables and added some measures.  

So the "MeasureTable" table has 'Name' column and some measures. 

Now, I created a table visual called "Main" and taken data from "MeasureTable"

However, I want to have another table visual called "Summary" having maximum, minimum and average of each column from the "Main" table visual. 

As the columns from "Main" table visual are taken from measures, I am unable to create maximum, minimum and average of those column in my new table visual. 

Can anyone help with this? 

Thanks in advance.

[tharunkumarRTK · Accepted solution]

@bhargavanand 

If I assume you did not add any column into your 'Main' table visual then there wont be any Max or Min values for those measures, considering you are summarizing them against any column. Or if you would have included any dimension filed along with the measures then to get the max or min value you can create new measures with the below pattern

[MaxOfSalesMeasure] = MAXX(all(Table[Column] ), [SalesMeasure] )

follow the instructions here: https://dax.guide/maxx/ 

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[bhargavanand]

Thanks for your reply. In this measure [MaxOfSalesMeasure] = MAXX(all(Table[Column] ), [SalesMeasure])
can I also add a filter like, [SalesMeasure] > 0?

[tharunkumarRTK]

@bhargavanand 
Yeah you can 

[MaxOfSalesMeasure] = MAXX(all(Table[Column] ), if( [SalesMeasure]>0, [SalesMeasure]). )

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun