Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can anyone help this.

 

Thanks,
JS

Tutorial Requests

4 Replies

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    air code

     

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

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
        CahabaData
        Memorable Member
        9 years ago

        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?

  • RoRo's avatar
    RoRo
    Regular Visitor
    9 years ago

    Hello,maybe the following code will help you :

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