Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dax for maxif

Hi,   Please can you tell me the dax formula to find the column "Maximum Sales In Area"? (for each row it should find the maximum number of sales for the branch with the most sales in the same area...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

     

    Hi, lets try with:

    Calculated Column

     

    MaximumSalesinArea =
CALCULATE (
    MAX ( Table2[Sales] );
    FILTER ( Table2; Table2[Area] = EARLIER ( Table2[Area] ) )
)

     

    Regards

     

    Victor

    Lima - Peru

tecumseh's avatar
tecumseh
Resolver III
2 years ago

Vvelarde 

I built this faithfully to understand Earlier.
I am receiving an error message:

EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

My DAX:

MaximumSalesInArea =

CALCULATE(

    MAX( Table2[Sales] ),

    FILTER(

        Table2,

        Table2[Area] = EARLIER( Table2[Area] )

    )

)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Write it as a calculated column formula (not as a measure).