Forum Discussion

JacobMotu's avatar
JacobMotu
Frequent Visitor
3 years ago
Solved

Filter slicer values based on multiple conditions

Download pbix: This is the report with close-to-original data + data model. Goal: I want to filter values that appear in my Block slicer in a way that there are only the blocks that have more than...
Need Help
  • JacobMotu's avatar
    JacobMotu
    3 years ago

    I solved that with this measure. I use the measure to filter the Block slicer (is greater than 1).

    2DataPointsSoilBlock = COUNTROWS(
  FILTER(
    SUMMARIZE(
      tblSoilDetail,
      tblSoilDetail[Block],
      tblSamples[Year]
    ),
    [Block] <> BLANK() && [Year] <> BLANK()
  )
)
JacobMotu's avatar
JacobMotu
Frequent Visitor
3 years ago

I solved that with this measure. I use the measure to filter the Block slicer (is greater than 1).

2DataPointsSoilBlock = COUNTROWS(
  FILTER(
    SUMMARIZE(
      tblSoilDetail,
      tblSoilDetail[Block],
      tblSamples[Year]
    ),
    [Block] <> BLANK() && [Year] <> BLANK()
  )
)