topic Re: How to split the charts based on Year and production center to get Deliver quantity count in DAX Commands and Tips

How to split the charts based on Year and production center to get Deliver quantity count

Anonymous — Tue, 19 Jul 2022 07:12:57 GMT

I am trying to get Delivery quanioty count two split like year 2021 and 2022 & Production center UAO1 and UA01

Production Center Goods Issue Date Delivertquantiy

UA01 06-01-2021 1050

RU02 13-01-2021 1050

UA01 20-01-2021 1050

RU02 06-02-2021 111

UA01 13-02-2021 75

UA01 20-02-2021 430

UA01 06-01-2022 640

RU02 13-01-2022 640

UA01 20-01-2022 640

RU02 06-02-2022 130

RU02 13-02-2021 145

UA01 20-02-2021 245

I have added year slicer and Production center . i am trying to set two x axis one for year 2021 and 2022. also for two axis in single graph one for production center UA01 and another one RU02. i created two measure like below

2021 dATE = CALCULATE(COUNT('Raw Data'[Delivery quantity]),DATESBETWEEN ('Raw Data'[Goods Issue Date],DATE(2021,01,01),DATE(2021,12,31)))

But when i creating 2022 measure i am getting below Error

<pi>A circular dependency was detected: Raw Data[2022 DATE], Raw Data[2021 dATE], Raw Data[2022 DATE].</pi>

2022 DATE = CALCULATE(COUNT('Raw Data'[Delivery quantity]),DATESBETWEEN ('Raw Data'[Goods Issue Date],DATE(2022,01,01),DATE(2022,12,31)))

Looking for support. thanks in advance.

Re: How to split the charts based on Year and production center to get Deliver quantity count

amitchandak — Tue, 19 Jul 2022 12:23:26 GMT

Anonymous , Do not use time intelligence function on table, prefer date table try like

CALCULATE(COUNT('Raw Data'[Delivery quantity]),Filter( 'Raw Data', 'Raw Data'[Goods Issue Date] >= DATE(2022,01,01) && 'Raw Data'[Goods Issue Date] <= DATE(2022,12,31)))

or all

CALCULATE(COUNT('Raw Data'[Delivery quantity]),Filter(all( 'Raw Data') , 'Raw Data'[Goods Issue Date] >= DATE(2022,01,01) && 'Raw Data'[Goods Issue Date] <= DATE(2022,12,31)))

Re: How to split the charts based on Year and production center to get Deliver quantity count

Anonymous — Fri, 22 Jul 2022 02:52:38 GMT

Hi Anonymous ,

Does the answer to amitchandak 's give you a solution? If so, please mark his answer as the solution. If not, please provide your pbix file without privacy information and more details with your desired output. (Or some sample data in a pbix file and desired output.)

How to Get Your Question Answered Quickly

Best Regards
Community Support Team _ Polly

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

Re: How to split the charts based on Year and production center to get Deliver quantity count

Anonymous — Fri, 22 Jul 2022 04:43:47 GMT

amitchandak thank you sir