Filter a Line Chart via DAX Measure to report ONLY for Max Date
Hi all, I have a requirement from our userbase that they'd like to be able to switch between measures reported in a line chart. The trouble I'm running into is that some of these measures can only be reported as of the max date - metrics such as Open Roles, % of Employees on a Succession Plan, etc. Using the 'Open Roles' measure as an example, when a user selects the option on the left for 'Open Roles', I'd like the Line Chart to ONLY report the value for the maximum selected date and exclude the other Month/Year values from the axis: I've tried MAX/MAXX/etc but am coming up short. Any ideas?
Return Max Value of Category when Data has Two Different Demands With and WIthout a Subcategory
Hello, I’m trying to list two different demands for each Category in a table, one of which has the demand further broken down by Type but where this isn't the case for the other, which just has the aggregated value for Category. The Category also needs to be mapped to its particicular month - there are repeating Category names populating different months in the year - and work with further filter contexts in the table. For the demand without the breakdown by Type, I understand I need to return the max value per Category rather than having all the values summed. An example of the data is shown below: My data repeats across the year for different Categories but as seen, is only broken down by Type for Current Demand. When I list things in a table, I’m looking for a way to list both demands to compare but importantly, also a way to list the demand by Type for Current Demand (or ideally any other field whether at a more aggregated or broken down level) even though we don’t have this level for Previous Demand. Whether Previous Demand just shows no entries or has fake placer values to reach the correct aggregate I’m not much fussed about. So far I have tried creating the following measures but with no success: Previous Demand Max = MAX(Products[Previous Demand]) Previous Demand = CALCULATE([Previous Demand Max], ALLEXCEPT(Products, Products[Category])) Any ideas on how I could acheive this would be much appreciated.
