Measure is returning 0 or blank when being used in another measure

[watson456]

Hey all, trying to get a measure to work where i'm comparing the age of an item in a developement phase (days), to the overall value for a higher level (so this is item in a team compared to the overall value from a higher level of release train.)

The following is the calculation i'm trying

FeatureAgeInProgressColor =

            Calculate(sumx(Rally_Combined_WorkItems,[FeatureAgeinDiscovery])) /

                ROUND(

                        CALCULATE(

                            CALCULATE(PERCENTILE.INC(Rally_Combined_WorkItems[FeatureAgeinDiscovery],.5),

                                TOPN(30,Rally_Combined_WorkItems, Rally_Combined_WorkItems[FeatureDevelopingDateAdjusted],DESC)),

                            All(RALLY_PROJECT[4. Team]),

                            All(Rally_Combined_WorkItems[FeaturePhaseCurrent]),

                            Rally_Combined_WorkItems[FeaturePhaseCurrent] in {"Feature Delivery", "Done"},

                            Rally_Combined_WorkItems[FeatureAgeinDiscovery] > 0)

                        ,0)

The 2nd part of the calculation where i calculate the 50th percentile of the last 30 items works on it's own and i am able to display it (see the table by the red line)

However when i place it in the calculation or run the 2nd part on its own and try to display it on the table, it shows as blank and in in the caculation divide by sero comes up understandably as infinity.

The table is filtered by the slicers on the page
Release Train
Team

Feature Phase

Not sure what other information would be useful here, but any help would be awesome

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[watson456]

Hi @Anonymous, i'll work on getting a sample data set into a PBIX to uplaod

[Anonymous]

Hi @watson456,

If you not have permission to upload the file to the forum, you can try to upload to network driver and share link here.  Notice: please not attach sensitive data in it.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @watson456 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng