calculate Minimum value based on Filter Selection

[sunilbhanushali]

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 value or when all Qtrs are selected, Q1 has minimum value hence last column is showing minimum value 100

Scenario 2

But now user can change filter condition on Qtr and can select Q2,Q3 and Q4 and hence minimum value will change now to that of Q2 which is 200

I am using Direct query mode to fetch the results.  Year and Amt are coming from two different tables.

I am trying to write DAX by creating measure for e.g. 

min_amt = CALCULATE(min(amt),ALLEXCEPT(table,table[Qtr])

but still no luck as it is still showing 100 even when I am not selecting Q1 as part of my filter condition.

[v-yetao1-msft]

Hi @sunilbhanushali 

Please try a measure like this :

Min Amt = CALCULATE(MIN('Table'[Amt]),ALLSELECTED('Table'))

And the final result is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

Please share sample data I will try on it 

[mh2587]

min_amt = CALCULATE(min(amt),ALLSELECTED(table,table[Qtr])

Just change allexcept with allselected hope it will work

[sunilbhanushali]

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]))