Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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>
Solved! Go to Solution.
@THENNA_41 , 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)))
Hi @THENNA_41 ,
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.
@THENNA_41 , 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)))
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |