Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 - measure
Issue Rate = CALCULATE( DIVIDE( COUNTA(ISSUES[type]), DISTINCTCOUNT(REPO[id])))
DAX 2 - CALCULATED COLUMN TO FILTER THE CURRENT WEEK
Latest Week Check = IF(AND(REPO[Week]<LOOKUPVALUE('Dates'[Fiscal Week],'Dates'[Day],REPO[Today]),REPO[ Week]>=DATE(YEAR(REPO[Current Week]),MONTH(REPO[Current Week]),DAY(REPO[Current Week]))-7), "YES", "NO")
To filter the column chart to show the current week data I have added this caculated colum to filters pane and Selected "YES"
Now, I am creating a new tool tip that removes Latest Week Check filter and show the entire data for all the weeks
TOOL TIP
X is REPO[Week]
Y is Issue Rate All (New measure to remove the filter)
Issue Rate All = calcualate (REPO[Issue Rate], Removefilters[repo[Latest Week Check])
I have tried different variations for this ISSUE RATE ALL DAX - REMOVEFILTERS, ALL, ALLEXCEPT. Nothing seems to work I am not sure what column to use also. Let me know where I am going wrong or any other workarouds. Thank you so much.
Solved! Go to Solution.
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 )
)
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 )
)
It worked. Thank you so much
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |