Add 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.
Exclude Users from Ranking RANKX
Jolly Day, I am needing to exclude three users from being included in the ranking. What I currently have just inserts a dash where there ranking number would be and are still being ranked. Could someone help me with a measure to completely exclude them? Entry Rank = IF(SELECTEDVALUE (System_Users[Account]) IN {"cbelcher","pkessell","kcole"}, "-", RANKX(ALL(System_Users),Audit[Sum Entry]) ) Many thanks in advance!Want measures to exclude calculation when date doesn't exist.
Completed hold stage for the top three rows hasn't got a completion date populated yet and it's defaulted to 44798.00 All the rows under this dont have a completion date for complaint actionable and it's doing the same thing. I want the DAX to give today's date if there is no completion date populated but only if the action EXISTS. I'm trying to get this to show the amount of time for each measure in days. Here are the two measures: Completed Holding stage age = VAR startdate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt]) VAR enddate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1002"), hgmcntac[completed_dt]) RETURN ROUNDUP((enddate - startdate) * 1,0) Complaint actionable = VAR enddate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt]) VAR startdate = MAX(hgmcntct[taken_by_dt]) RETURN ROUNDUP((enddate - startdate) * 1,0) Thanks in advance, DanHow to exlude SUM of zero
Hi, Here is a measure SUM (0+0+0+0.6+0.6+0.6...) divided by COUNT of dates. The question is how to exclude those dates when summary equals 0.00 from this calculations? Currently it calculates: 4.2 / 12 = 0.35 I need it to calculate: 4.2 / 7 = 0.6 the reason 0.00 is showing for some dates is because in the data there is 0.6 but later on there was another data added with -0.6 for those dates. Hence below we see the summary. Thank you!
