Forum Discussion

manuellchavez's avatar
manuellchavez
Icon for Advocate I rankAdvocate I
6 years ago
Solved

DAX Measure - Ignore specific filter but keep some others

Hello, I am trying to create a visual similar to the one below: The first measure is something like this: Quantity = calculate(sum(quantity),filter(colortable, colortable[date]=max(masterd...
Need Help
  • AlB's avatar
    AlB
    6 years ago
    Quantity =
CALCULATE (
    SUM ( colortable[quantity] ),
    FILTER ( ALL( colortable[date] ), colortable[date] = MAX ( masterdate[date] ) ),
    ALL ( colortable[color] )
)

    If this doesn't work do share the pbix or at least a sample of your tables (in text-tabular format, not screen capture)

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Cheers  Datanaut

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Hi manuellchavez 

You'd just need an ALL on the colour column:

Quantity =
CALCULATE (
    SUM ( colortable[quantity] ),
    FILTER ( colortable, colortable[date] = MAX ( masterdate[date] ) ),
    ALL ( colortable[color] )
)

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut

  • manuellchavez's avatar
    manuellchavez
    Icon for Advocate I rankAdvocate I
    6 years ago

     Thanks for the response AlB , unfortunatelly it is still not showing the total sum on each row, just the total for each color.

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      6 years ago
      Quantity =
CALCULATE (
    SUM ( colortable[quantity] ),
    FILTER ( ALL( colortable[date] ), colortable[date] = MAX ( masterdate[date] ) ),
    ALL ( colortable[color] )
)

      If this doesn't work do share the pbix or at least a sample of your tables (in text-tabular format, not screen capture)

       

      Please mark the question solved when done and consider giving kudos if posts are helpful.

      Cheers  Datanaut