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

Vvelarde's avatar
Vvelarde
Community Champion
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