Dax Calculate + filter doesn't show correctly on visual

[Anonymous]

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.

Can anyone help this.

Thanks,
JS

[RoRo]

Hello,maybe the following code will help you :

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

[CahabaData]

air code

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

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

[Anonymous]

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.

[CahabaData]

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?