Forum Discussion

rithu's avatar
rithu
Frequent Visitor
3 years ago
Solved

Urgent Help : Remove filter from a MEASURE using DAX

I need to remove a filter from a measure.    I have 3 tables - REPO, ISSUES and DATES   I have a column chart X is district and Y is this measure ( Issue Rate )   In Report table - DAX 1 - mea...
Get Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi rithu 

    Create a Slicer Table that of a single column that contains "Yes" and "No" and link it to the Latest Week Check column and use it in the slicer. The the tooltip measure would be

    Issue Rate All =
    CALCULATE (
    [Issue Rate],
    CROSSFILTER ( REPO[Latest Week Check], SlicerTable[Last Week Check], NONE )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi rithu 

Create a Slicer Table that of a single column that contains "Yes" and "No" and link it to the Latest Week Check column and use it in the slicer. The the tooltip measure would be

Issue Rate All =
CALCULATE (
[Issue Rate],
CROSSFILTER ( REPO[Latest Week Check], SlicerTable[Last Week Check], NONE )
)

  • rithu's avatar
    rithu
    Frequent Visitor
    3 years ago

    It worked. Thank you so much