How to calculate a measure with a min selected value of a field ?

[Bebs]

Hi,  

I've a text field called "Version" which can contains V1.0, V2.0 etc ...

Users can make any selections on the version field, then I want to display in a matrix table a column with a calculation for minimum version and a column for maximum version. If we focus only on minimum version :

I create a measure to calculate the min selected version :

BUDGET_MIN = CALCULATE(MIN(data[VERSION]),ALLSELECTED(data[VERSION]))

=> it works

My normal calculation :

BUDGET = CALCULATE( Sum(data[AMOUNT]),FILTER(data,data[CATEGORY]<>"HOURS"))

=> it works

Note : for filter FILTER(data,data[ACCOUNT]<>"HOURS"), we juste need to keep in mind, we need that filter (no matter what it does).

Now i'd like to create a measure calculating the Budget for the minimal budget version, I tried :

CALCULATE(
Sum(data[AMOUNT]),
FILTER(data,data[CATEGORY]<>"HOURS"),
FILTER(data,data[VERSION]=measures[BUDGET_MAX])
)

or else

CALCULATE(
Sum(data[AMOUNT]),
ALLSELECTED(data[VERSION]),
FILTER(data,data[CATEGORY]<>"HOURS"),
FILTER(data,data[VERSION]=measures[BUDGET_MAX])
)

it doesn't (data are not of the right Version)

could you please help me about the correct syntax please ?

Best regards

[Bebs]

Here is a little sample :

-----

Edit : do you know how to attach a pbix ? it doesn't seems to work

[mangaus1111]

you have to share a OneDrive link

[v-yinliw-msft]

Hi @Bebs ,

I'm not sure what the data will look like.

Could you please provide me with some sample data for testing? Please delete sensitive private data.

Best Regards,

Community Support Team _Yinliw