Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
Share sample pbix file to help you.
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 32 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 82 | |
| 66 | |
| 42 | |
| 27 | |
| 25 |