Help with DAX for - Calculate MIn

[JV0710]

Hi

Please can I have help with the following query.

I have a PowerPivot file where I have columns for product, season value, and various measures e.g receipts

I am trying to create a column that will show the earliest season a product is received

example: I have a product that was received in Season 1, but has sales for all seasons.
In the column "Received season" I want to see season value " 1 " next to every occurrence of the product

currently I have the following dax formula but it is not working

=CALCULATE(MIN(Query[season value]),Query[MeasuresReceipts]>0)

Thank you in advance for your help

Joe

 

[esadovnic]

Hello!

Without seeing the workbook in context, have you attempted to throw in a FILTER() before the second param in the calculate? =CALCULATE(MIN(Query[season value]), FILTER(Query, Query[MeasureReceipts])>0)

Let me me know if that makes a difference.

 

[JV0710]

Good Morning

Thanks for the help. I have tried your suggestion but I get the following error when doing so:

" A function 'Filter' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Thanks

Joe

 

[JV0710]

Hi

I have found a solution to the problem

The final result is the following DAX formula:

=CALCULATE(MIN(Query[season value]),ALLEXCEPT(Query,Query[product]))

Thanks

Joe

 

[esadovnic]

Glad you found a solution!