With or Without FILTER in measure
I'm a bit confused about the FILTER function There're two tables: Date (with a one-to-many relationship) → Revenue Sunday is the first day of week. Assume today is 5 Jul 2025 (Sat). I need to create a table to compare revenue for current week (29 Jun - 5 Jul 2025) vs same week last year (30 Jun - 6 Jul 2025). I’ve disabled the start date selection in the date slicer to prevent users from selecting an incorrect start date, which could disrupt the prior year calculation. There is a column - First Day of Week_RankDESC which ranks the first day of each week in descending order, so current week is MIN('Date'[First Day of Week_RankDESC]) I have two questions. 1. Why are the results different between the two measures below? I thought both were filtering the rank to the current week. e.g. CurrentYearWeekRank = MIN('Date'[First Day of Week_RankDESC]) Without FILTER CALCULATE(SUM(Revenue[Revenue]), 'Date'[First Day of Week_RankDESC] = CurrentYearWeekRank) FILTER CALCULATE(SUM(Revenue[Revenue]), FILTER('Date', 'Date'[First Day of Week_RankDESC] = CurrentYearWeekRank)) 2. If I select end date - 2 Jul 2025 (Wed), both tables still show revenue for Thur, Fri, Sat for current week. Why? Thanks in advance:) https://drive.google.com/file/d/1n0UqUtWKyvxoL_0XuEqJY18ZzZzTzlwU/view?usp=sharing
Help Calculating Average Excluding 2 Conditions
I have an existing DAX measure which gets average of completed fields in the "Master AE" table (there's 35 required fields): [EPIC %] = CALCULATE( DIVIDE([EPIC Points], COUNTROWS('Master AE')*35)) The current measure gives this output on my KPI cards, which is correct: However, I need to modify it to get a new average that EXCLUDES any rows where Master AE [EPIC Points Count] is <=17 AND the Master AE [Quarter] is > 2. Or basically, exclude any results from EPIC % measure result <= 49% AND Quarter > 2. The desired result average should be 40.28% (only 10 values would be averaged per the conditions) Any idea how I can do this? Here is the [EPIC points] measure which sums all the points assigned when blanks completed: Appreciate any help!
ToolTip Advance - Filter Help
Hi all, I'm working on a Power BI report where I show monthly Gross Sales in a table and would like to display a tooltip chart when hovering over the table rows. The goal of this tooltip is to show the entire year's trend line for Gross Sales, not just the single month that was hovered. What I want: When hovering over a row (e.g., Brand 3), I want the tooltip to show a Bar chart for the full year (e.g., Jan–Dec ). The tooltip should still respect other slicers from the main page: e.g., State but ignore Month Slicer What I’ve Tried: Created a Tooltip Page. Enabled the page as a tooltip and linked it to the table. It works — but only shows a single month (the row context from the table). However, the date context from the hovered row still dominates the chart axis — only one Bar appears instead of the full year. What I Need Help With: How can I structure my tooltip chart (and DAX) to: Ignore just the row-level month/date from the hovered row Still respect the full context of slicers (State etc.) Always show the full year trend on the tooltip chart? File working
Ignore filter on my measure
Hello, I’m using a Sparkline generated via an API, and it’s working perfectly. Each dot corresponds to a week, allowing me to see the variation over time from the start of my dataset. However, I’ve encountered a challenge: I want to filter my page data (e.g., using a slicer) to focus on specific weeks, such as Week 31 of the year. This should dynamically update all visuals on the page. However, I also want the Sparkline visual to always show the total data (ignoring any filters) to provide a full historical view. I can’t disable the interaction between the filter and the Sparkline visual because I’m also using a card and a main measure on the page. These elements need to reflect the filtered data based on the selected date range. Here’s the current code for my Sparkline: As an example, here's how it looks like when no filter is applied : And here is how it looks like when I filter on 3 weeks : The data change to 5484 which is great but my sparkline also changes as well, I would like it to stay unfiltered. Thank you in advance.
