Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bhargavanand
Frequent Visitor

Dynamic summary table based on table visual data

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.

1 ACCEPTED SOLUTION
tharunkumarRTK
Solution Sage
Solution Sage

@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



View solution in original post

3 REPLIES 3
tharunkumarRTK
Solution Sage
Solution Sage

@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



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

@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



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors