Forum Discussion

bgarland's avatar
bgarland
Helper I
8 years ago

Count, Ignore Slicer

This should be really easy but I can't figure it out. I've got one card that shows a count of a column based on what is selected in a slicer, and another card that should show the count of the same c...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

What is the formula for your second measure? It should have an ALL in it. Like a COUNTX(ALL('Table'),[Column])

  • bgarland's avatar
    bgarland
    Helper I
    8 years ago

    You should be able to see it in that screenshot, but here it is:

     

    Total Count of JRS Lag = calculate(count('Product Rotation'[JRS Lag]), all('Product Rotation'[JRS Rotation Lag]))

    • bgarland's avatar
      bgarland
      Helper I
      8 years ago

      Looks like we have a weird data issue and it's not a Power BI problem. Thanks for looking.