Forum Discussion

sunilbhanushali's avatar
sunilbhanushali
New Member
4 years ago

calculate Minimum value based on Filter Selection

I want to find minimum value and put it in seperate column to show and this minimum value would change based on the selection done.   Scenario 1       When there is no seletion on Qtr val...
Need Help
mh2587's avatar
mh2587
Super User
4 years ago
min_amt = CALCULATE(min(amt),ALLSELECTED(table,table[Qtr])

Just change allexcept with allselected hope it will work

sunilbhanushali's avatar
sunilbhanushali
New Member
4 years ago

Hi,

 

i had tried ALLSELECTED too but it didn't work. I also tried using summerize funcatin with no luck

 

v_min_amt = 
var grpby = SUMMARIZE(
            table,
            table[Qtr]
            )
return minx(grpby,min(table[amt]))