Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I'm really struggling with this one. Can any one help
Hi @dmbd1904 ,
Please share pbix file without sensitive data. it is hard to fix it without data.
Best Regards
Community Support Team _ chenwu zhu
Hi @v-chenwuz-msft the pbix file can be retrieved from here https://we.tl/t-5GlTum5eII
Hi @v-chenwuz-msft just wondering if you managed to take a look. I attach another link to the file https://we.tl/t-fl4FGJmi9G
Hi @dmbd1904 ,
This is Circular Dependency error in DAX.
You should add allexcept() to CALCULATE() function.
You can try the following code:
Standing Time =
VAR Location = COR_DepthRelatedExploratoryInformation[LocationDetails]
VAR Startdate = COR_DepthRelatedExploratoryInformation[DateTimeStart]
VAR Enddate = COR_DepthRelatedExploratoryInformation[DateTimeEnd]
RETURN
CALCULATE(
SUM( COR_TimeRelatedRemarksLocation[Working Hour Duration] ),
ALLEXCEPT( COR_TimeRelatedRemarksLocation, [primary key column] ),
COR_ProgressByTime[LocationDetails] = Location,
COR_TimeRelatedRemarksLocation[DateTimeStart] >= Startdate,
COR_TimeRelatedRemarksLocation[DateTimeEnd] <= Enddate
)
For more detail of Circular Dependency error in DAX, please refer this article.
https://www.sqlbi.com/articles/understanding-circular-dependencies/
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dmbd1904 , Try like. I am assuming you are creating a new column
Standing Time = VAR Location = COR_DepthRelatedExploratoryInformation[LocationDetails]
VAR Startdate = COR_DepthRelatedExploratoryInformation[DateTimeStart]
VAR Enddate = COR_DepthRelatedExploratoryInformation[DateTimeEnd]
RETURN CALCULATE(SUM(COR_TimeRelatedRemarksLocation[Working Hour Duration]),Filter(COR_TimeRelatedRemarksLocation ,COR_ProgressByTime[LocationDetails]=Location && COR_TimeRelatedRemarksLocation[DateTimeStart]>=Startdate && COR_TimeRelatedRemarksLocation[DateTimeEnd]<=Enddate) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |