Forum Discussion

bhargavanand's avatar
bhargavanand
Helper I
2 years ago
Solved

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. ...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    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



tharunkumarRTK's avatar
tharunkumarRTK
Super User
2 years ago

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's avatar
bhargavanand
Helper I
2 years ago

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

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    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