Forum Discussion

Vladracs's avatar
Vladracs
Helper I
3 years ago

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!

Now if I want to create a table for each bank and show all Indices, the minimo and max values are messed up:

 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