Forum Discussion
PowerBI CycleTimeDays average and Azure DevOps Cycle Time widget does not return me the same number
HI fcoalcantarajr,
I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.
Regards,
Xiaoxin Sheng
Hi fcoalcantarajr,
Where did the first result geted? I check your sample file and find the both two card get the same result.(one of aggregated on table fields, the other is measure formula)
If you mean the sample file result, you may need to check the report data source if they not static. The expression result is based on row context, and it may not get the same result if the underlying data records changes.
Regards,
Xiaoxin Sheng
Hi Anonymous
I didn't quite get your message, sorry. =(
But yes, the data is not static, it keeps changing. The source is a Feed OData connection with Azure Boards.
HI fcoalcantarajr,
I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.
Regards,
Xiaoxin Sheng
Hi, the line chart and card visual sometimes get the same result, but not always. Sometimes it returns wildly different results.
For example, these values are for the same organization. Filters were setup correctly.