Return Max Value of Category when Data has Two Different Demands With and WIthout a Subcategory

[Anonymous]

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.

[andhiii079845]

Please make a little example with a table. This more easier what do you want to see. 

[Anonymous]

I've managed to fix this now in a different post on the other way to tackle this (transforming data in PQ), but thank you anyway. I was probably overcomplicating here.

[andhiii079845]

Can you share please the underlaying data and a example want you really want.  A good example is more than 100 word 🙂

[Anonymous]

I think an easier solution to my issue is whether there is a way to change the repeating values in my Previous Demand column to null/zero. Therefore, in my example, I would just have one '40' value within the index Jan 23 - Bicycle. Does anyone have any idea?