Have a grouped table but being able to filter by grouped data

[nicolasvc]

I have a table like this:

Center	year	month	week	sku	supply	demand
1	2021	01	01	0123	3000	2500
1	2021	01	01	0124	2500	1000
1	2021	01	02	0123	3000	2000
1	2021	01	02	0124	5000	2000

And I create another table in power bi (not in power query), with which I create this table but grouped by sku, and subtracting the supply with the demand (and adding, since it is grouped). But I would like later in the graphics to be able to select the sku that are put in some graphic. Example to show the supply-demand column with the date axes, but to be able to make a filter if I want to put more or less sku, how could I do it?

Center	year	month	week	supply-demand
1	2021	01	01	2000
1	2021	01	02	4000

[jaideepnema · Accepted solution]

Hi @nicolasvc ,

I am not sure why have you created the second table. As you can create a meaure like this :

Supply-Demand = sum('Table'[supply])-sum('Table'[demand])

Use this in a table and add a slicer for SKU as shown below:

Hope this resolves your query !!

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[nicolasvc]

Thanks for the advice!, but what happens is that I create the table because then I have to do calculations occupying previous cells, so I use the EARLIER function, I don't know if it can be used with measures.  Can be done?

[jaideepnema]

@nicolasvc Yes that should be possible !!