Filter Matrix visual based on the current level In Scope, without affecting not in Scope values.
Hi All, I'm trying to filter a Matrix visual based on a measure value category (segmenting the measure values). the problem is that the filter is filtering all rows in the visual, while the desired result would be just filtering the rows in the current context (i.e. based on the currently visible hierarchy of the matrix). For Example, the delta% value of OFQ subsystem was 60.6% before filtering, and when a filter was applied the value changed to 79.7%. what is happening is that the filter is filtering out the rows in the next level ([Area] in this case); thus the value changes accordingly. The desired output is to keep the 60.6% value as it's. and this should by dynamic based on the currently displayed level. After a long research and trials, I've tried to detect the current displayed level using ISINSCOPE/HASONEVALUE functions, then exclude next level values with ALLSELECTED/REMOVEFILTERS. but it doesn't seem to detect the current level in scope correctly. Hope you can help me here. Please note that I can't create the category filter in a column since all of my values are based on slicers selections; thus, I can't summarize the data in a table or a column. that's why I had to use a measure and add it to visual filters. here is a sample report that mimics what I'm trying to do: question.pbix Thanks a lot,,
Rolling 4 Quarters Based on Slicer Selection
Hi everyone, I've been stuggling to figure out a solution and hoping that someone in this community could point me in the right direction. End Goal: Table/Matrix the displays only data for Last 4 Quarters based on slicer selection I found the following post here, and was able to implement for my situation and it is mostly working: link Summary: use a disconnected date table and a flag measure to flag the last four quarters. Then, use a visual level filter and the flag measure to filter for only for quarters with "Y" as these are the last four quarters Here is the measure I'm using to flag the last 4 quarters: R4 Quarter Flag = VAR _max = SELECTEDVALUE ( 'Date Copy'[Quarter Index] ) VAR _min = CALCULATE ( MAX ( 'Date Copy'[Quarter Index] ), FILTER ( ALL ( 'Date Copy' ), 'Date Copy'[Quarter Index] = SELECTEDVALUE ( 'Date Copy'[Quarter Index] ) - 3 ) ) VAR TimeFrame = MAX ('Date'[Quarter Index]) RETURN IF ( TimeFrame <= _max && TimeFrame >= _min, "Y", "N" ) Issue: This approach doesn't seem to work when there are rows added to the matrix from other tables - ie a location table. See attached pbi file for example of the issue: pbi example - google drive The first matrix shows the R4 quarters, which is how this should work The second matrix includes the location code, which causes the R4 quarter flag filter to no longer work I imagine that there is something in the DAX of the R4 quarter flag that is cuasing the rows to override the column filter, however, I am not able to figure out what is causing this It would be so appreciated if anyone is able to provide any suggestions how to make this work when there is row data as well. Thank you in advance for your help!
Distinct Count for a card visual based on a measure (Visual Level Filter)
Hi, I have created a measure - "Measure1". I have created a table visual with Measure1 applied as a visual level filter with values > 1. Screenshot below: Now I am trying to create a CARD visual showing the count of Drivers that is shown in the above table. But the card visual does not accept a measure as a visual level filter. Count of Distinct Drivers = DISTINCTCOUNT('Table'[Driver Name]) So, I am trying to figure out a DAX measure that would solve this. Any help will be appreciated.
