include
2 TopicsAdd option for "Page Level" Include/Exclude filtering in every Visual's right-click menu
Current State: You can right click a value on a visual and choose INCLUDE or EXCLUDE. This adds a VISUAL-level filter in the filter pane. IDEA: It would be awesome if we also had an option for "INCLUDE @ Page Level" and "Exclude @ Page Level." For example: If you right click "INCLUDE @ Page Level" something like one of these options happens... Field is NOT set up as page-level filter = Field is added as a page-level filter Field was already set up as page-level filter = Existing page-level filter criteria is updated Field was already set up as page-level filter = secondary page-level filter is added for that value Benefits: Quick way to apply a page filter while you are exploring data and interacting with visuals (vs pausing to hunt through the filter pane or page slicers). Often times you discover that your report does not have the page filter you need set up. This can mean that you have to bother the report owner and ask them to add the page filter. Also the page-filter may be a one-off need and we dont want to save it amongst the other common page-level filters we already have saved in the report. This idea makes it so you dont need a report designer to add the filter... and it also makes temporary.3.4KViews3likes0CommentsMeasure to include a filtered out value
I am currently attempting to create a measure that returns a calculated value based on a certain role and type. There are two roles, each role is associated with numerous types. I am trying to forcefully include a certain type within a certain role even though it is associated with a different role. Please refer to the example below for further clarification. Role Type Value Dp1 jacket 50 Dp2 watch 20 Dp2 shorts 15 Dp2 socks 5 Dp1 sandals 25 Dp1 pants 20 Dp1 shirt 10 Lets say, I wanted to create this measure for all of "Dp1" but include the "watch" from "Dp2." There measure should then return the count of the total items. In this case, 5. As there are 4 items from "Dp1" + the "watch" from "Dp2." Please note, in my data there are numerous duplicates of each type and role. All I need is a measure that calculates the total number of rows. Now I could manually go in and define each type I want the measure to include, the problem with that is in the future, new types most likely will be added to each role. So having to manually define each type to include is not a valid solution. Associated to this problem is a measure I created to filter out a certain type from a certain role. This measure works as intended. You can see this below. Measure = CALCULATE(DISTINCTCOUNT(Table1[Value]), , FILTER(Table1, Table1[Role] = "Dp2",) FILTER(Table1, Table1[Type] <> "watch")) Please note, I am working inside of a dataset and cannot access the features to create calculated columns. Otherwise, that would be my go to method. Also, I intend to display this measure on a graph, each column showing the value by type. Any assistance on this measure would be greatly helpful.Solved922Views0likes1Comment