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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Vladracs
Helper I
Helper I

Filter down Min and Max

Hello Experts,

I am trying to find min and max values for a given Indice for all banks listed in the filtered table.
In image below everything workes fine as I have 1 Value per Indice , and the result for each Bank is correctly calculated.
Minimo = calculate(minx(values(dimBANCOS[Banco]), FACTTABLE[_Valor*100]), allselected())
as you can see minimo = 71.10 which is the smallest value listed - so we are good!

Screenshot 2023-06-18 at 19.59.56.png

Now if I want to create a table for each bank and show all Indices, the minimo and max values are messed up:
Screenshot 2023-06-18 at 20.01.21.png

 I'd like to show the min and max value for each Indice calculate for all banks and NOT on each row


If I manually filter per Segment of the Bank it is giving me the result I need though:
_Min_Segment = calculate(100*min(FACTTABLE[VALOR]),dimBANCOS[Segmento]="DIGITAIS",ALL(dimBANCOS[Banco]))

But I would like to instead of creating 1 measure per segment , get the above working as per SLICER on Segmento

Let me know if the ask above is clear 

Best Regards,
Vlad



1 REPLY 1
Ahmedx
Super User
Super User

Share sample pbix file to help you.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.