Forum Discussion

harry6810's avatar
harry6810
Frequent Visitor
4 years ago
Solved

Filtering - DAX command

Hi, what is wrong with this command? 

Acer min = CALCULATE('Raportcen'[min.price],FILTER('Raportcen',Raportcen[producent]="Acer"))
 
I need to find the lowest price for Acer brand. The table as below. 

 


 

 
 
  • smpa01's avatar
    smpa01
    4 years ago

    harry6810  you need an aggregator here

     

    CALCULATE(MIN/MAX/SUM/AVERAGE('Raportcen'[min.price]),FILTER('Raportcen',Raportcen[producent]="Acer"))

1 Reply

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    harry6810  you need an aggregator here

     

    CALCULATE(MIN/MAX/SUM/AVERAGE('Raportcen'[min.price]),FILTER('Raportcen',Raportcen[producent]="Acer"))