Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Dax Calculate + filter doesn't show correctly on visual

Hi everyone,

 

Here is my dax code:

 

measure =
CALCULATE(
 SUM(Table1[Hours])
 ,FILTER(Table1, Table1[Float_Category] = MIN(Table1[Float_Category]))
 )

 

In the calculation, I already filtered table to show only the min value of [Float_Category]. But when I put the measure into a table or visual, all [Float_Category] values showed up.

Capture.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can anyone help this.

 

Thanks,
JS

4 REPLIES 4
RoRo
Regular Visitor

Hello,maybe the following code will help you :

measure =
CALCULATE(
 SUM(Table1[Hours])
 ,FILTER(Table1, Table1[Float_Category] = MIN(ALL(Table1[Float_Category])))
 )

CahabaData
Memorable Member
Memorable Member

air code

 

measure =
CALCULATE(
  SUM(Table1[Hours]),
     FILTER( ALLSELECTED (Table1),

        Table1[Float_Category] = MIN(Table1[Float_Category]) ) )

 

www.CahabaData.com
Anonymous
Not applicable

Hi @CahabaData

 

I have tried your code, still, doesn't work. 

If i put this measure into a "Card" visual, it showed correctly. 

But once i plot it on a "column chart", it showed everything. I was expecting to see only (x=0, y=200)

 

Seems that column chart type is overwriting the "Filter" function.

Capture.JPG

 

 

given the table data of your first post where each category has 100 hours; what is the correct Measure value for categories 0, 1 and 5?

www.CahabaData.com

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.

Top Solution Authors