Availability of the product in the menu

[Krzysiek87]

Hi DAX specialists, I have a problem in a restaurant, I am researching a certain sales period, and now I would like to know over the course of, for example: 6 months, how many days a given product was on sale. Based on this availability, what is the average sale per day but in terms of the actual availability of the product (first part of my question). Sample table below I will be much obliged for your help.

id_wpisu	TypTab	IdTab	Document	Restaurant	Date	Product	ProductGroup	Quantity
3936682592	2	32155038	PAR/32322	Restaurant A	2022-12-02	Burger Classic	NAPOJE ZIMNE	1
3936682593	2	32456038	PAR/32555	Restaurant A	2022-12-03	RedBUll	NAPOJE ZIMNE	1
3936682594	2	33723038	PAR/33866	Restaurant A	2022-12-10	Burger Classic	NAPOJE ZIMNE	1
3936682686	2	33844038	PAR/33904	Restaurant A	2022-12-10	RedBUll	NAPOJE ZIMNE	1
3936682687	2	33895038	PAR/33888	Restaurant A	2022-12-10	Coca Cola 0,2L	NAPOJE ZIMNE	1
3936682688	2	34348038	PAR/34265	Restaurant A	2022-12-12	Coca Cola 0,2L	NAPOJE ZIMNE	1
3936682689	2	35467038	PAR/35616	Restaurant A	2022-12-18	Burger Classic	NAPOJE ZIMNE	1
3936682690	2	35948038	PAR/35989	Restaurant A	2022-12-19	RedBUll	NAPOJE ZIMNE	1
3936682691	2	35951038	PAR/35994	Restaurant A	2022-12-19	Coca Cola 0,2L	NAPOJE ZIMNE	1

[Krzysiek87]

any one?

[ERD]

Hi. Can you show the result you want to achieve?

If you just want to calculate days, when products were sold, per product:

days = CALCULATE(DISTINCTCOUNT(T[Date]), T[Product] = SELECTEDVALUE(T[Product]))

[Krzysiek87]

It;s not work :((( this "SELECTEDVALUE dont work in powerpivot 😞

[ERD]

You can use MAX instead of SELECTEDVALUE.

[Krzysiek87]

still not work