topic Help with measure removing a column from the context in DAX Commands and Tips

Help with measure removing a column from the context

Quest — Thu, 17 Feb 2022 03:35:38 GMT

Hi all,

I have a table with numerous fields and I want to show a table in my report with following fields only:

Date, Product Category, Unit

This is how my data (fields I am trying to show in my table) looks like:

Date, product category, sales unit, forecast unit

Jan , A, 10, 10

Jan, B, 15,20

Jan, C, 15,10

Feb, A, 10,20

Feb, B, 10,10

I want to derive the final table as below. Note that units in this table is the forecast unit - sales unit for a month, without considering the product category.

Date, Product category, Units

Jan , A, 0

Jan, B, 0

Jan, C, 0

Feb, A, 10

Feb, B, 10

I tried using All and AllExcept, but didnt seem to work. I could be doing something wrong. Please help me with this.

Re: Help with measure removing a column from the context

amitchandak — Thu, 17 Feb 2022 03:48:30 GMT

Quest , Try a measure like

calculate(sum(Table[forecast]) - sum(Table[Sales]), filter(allselected(Table), Table[Date] =max(Table[Date])))

Re: Help with measure removing a column from the context

Quest — Thu, 17 Feb 2022 12:36:48 GMT

Thanks Amitchandak for the quick response. But this does not seem to be working for me.

Date, Product category, Units

Jan , A, 10

Jan, B, 10

Jan, C, 10

Feb, A, 10

Feb, B, 10

For Jan, the data should show 0 as the difference for Jan is 0 and for Feb it should show 10.

Re: Help with measure removing a column from the context

amitchandak — Thu, 17 Feb 2022 13:02:07 GMT

Quest , Please find if the attached file can help

Re: Help with measure removing a column from the context

Quest — Thu, 17 Feb 2022 14:31:10 GMT

Thanks a lot. I didnt create it as a measure, my bad.