Aggregation

[Anonymous]

is there a calculated formula to get minimum value of ON_HAND_QTY without using built-it options of aggregation.

[Fowmy]

@Anonymous 

Create a Measure:

Min_OnHand_Qty = MIN ( TableName[OnHand_Qty])

[Anonymous]

@Fowmy weird it's not working

[Fowmy]

@Anonymous 

Share some sample/dummy data and the expected results.

[Anonymous]

@Fowmy hi, created a sample pbix that you can use 

https://www.dropbox.com/s/2k5e9mbmzsh0cek/TEST.pbix?dl=0

my desired output is to create a calculated field for the actual MIN of OnHand without using built-in aggregated functions in PBI. it should show same value with the MIN (using built in function of aggregation)

[VahidDM]

Hi @Anonymous 

Try this:

measure = Min([ON_HAND_QTY])

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

Appreciate your Kudos!!

[Anonymous]

hello @VahidDM, not sure why it's not showing the correct value. value should be 35 and 13

[VahidDM]

add table name to the measure: measure = Min(table[ON_HAND_QTY])

Can you share a sample of your data?

Appreciate your Kudos!!

[Anonymous]

@VahidDM here is the sample data in the link below:

https://www.dropbox.com/s/2k5e9mbmzsh0cek/TEST.pbix?dl=0

[Anonymous]

hi still the same

[VahidDM · Accepted solution]

@Anonymous 

It works well with the previous code: 

Measure = min(Data[ONHAND_QTY])

Is there any difference between the file you shared and original file?

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

Appreciate your Kudos!!