Display Targets against No Sales

moses07_ferns — Mon, 29 Apr 2024 10:01:22 GMT

I have two tables . Target and Sales Table. I want to show sales for c and d as well with 0 sales and their respective targets.

Product	Target
A	50
B	25
C	30
D	10

Sales Date	Product	Sales
2/1/2018	A	2
2/2/2018	B	4
2/3/2018	A	1
2/4/2018	B	5
2/5/2018	A	7
2/6/2018	B	5
2/7/2018	A	2
2/8/2018	B	4
2/9/2018	A	1
2/10/2018	B	1
2/11/2018	A	3
2/12/2018	B	2
2/13/2018	A	3
2/14/2018	B	2
2/15/2018	A	3
2/16/2018	B	1
2/17/2018	A	2
2/18/2018	B	1

Desired Result :

Product	Sales	Target
A	24	50
B	25	25
C	0	30
D	0	10

Re: Display Targets against No Sales

Anonymous — Tue, 30 Apr 2024 01:49:42 GMT

Hi moses07_ferns ,

Depending on the information you have provided, you can add a new measure:

SALES_ = VAR _PRODUCT = SELECTEDVALUE ( 'Sales Table'[Product ] ) VAR _RESULT = CALCULATE ( SUM ( 'Sales Table'[Sales] ), FILTER ( 'Sales Table', 'Sales Table'[Product ] = _PRODUCT ) ) RETURN IF ( _RESULT > 0, _RESULT, 0 )

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Display Targets against No Sales in DAX Commands and Tips

Display Targets against No Sales

Re: Display Targets against No Sales