topic Re: Measure is returning 0 or blank when being used in another measure in DAX Commands and Tips

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

watson456 — Wed, 23 Aug 2023 04:54:25 GMT

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

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

Anonymous — Fri, 25 Aug 2023 01:13:16 GMT

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

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

watson456 — Mon, 28 Aug 2023 19:25:04 GMT

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

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

Anonymous — Tue, 29 Aug 2023 08:21:40 GMT

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

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

technolog — Sun, 24 Sep 2023 14:44:10 GMT

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.