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...
  • 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"))

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"))