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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.