Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
harry6810
Frequent Visitor

Filtering - DAX command

‎10-25-2021 09:39 AM

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. 
harry6810_1-1635179959718.png

 


 

 
 
Message 1 of 2
334 Views
0
1 ACCEPTED SOLUTION
smpa01
Super User
Super User

‎10-25-2021 09:42 AM

@harry6810  you need an aggregator here

 

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

Message 2 of 2
313 Views
1 REPLY 1
smpa01
Super User
Super User

‎10-25-2021 09:42 AM

@harry6810  you need an aggregator here

 

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Message 2 of 2
314 Views

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All