how to check how many parameters are passed to the parent hierarchy?

[wpf_]

If i have a measure that takes the average of a travel time for a particular stretch of highway.  And It is filtered to show for 3 different segments of the highway in a matrix.  

Then I have another measure that sums the first measure, which will add all three stretches of highways to calculate one virtual travel time to go from one place to another.  But if one stretch of the highway is down, I will not get data in the table and will be left blank in the matrix cell at the highway stretch level.  How can I check in the sum measure if at least one of the parameters are not present?  

[V-lianl-msft]

Hi @wpf_ ,

Not clear about your data model,maybe Parent and Child functions or ISINSCOPE  functions can help you solve the problem.

See if it will help you.

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/ 

If the problem persists,could you share the sample pbix via cloud service like onedrive for business?

(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Not sure how your measure are build, but this is an idea. 

Measure1 = Calculatestuffforsegments
Measure2 = SUM(measure1) 

If this is the case, the second measure would not be needed. If you put measure1 in a table with downtownNY and JFK airport i would expect the same results, because a measure is dynamic. Meaning it will calculate it again for every cell you use it. 

What im trying to say is that measure 2 does NOT look at the 3 different eastbounds when its being used in measure 2. And that is because it will do the calculation of measure 1 based on the field it is used in measure2. 

I hope this makes sence. We could maybe figure something out, but for that i need a bit more info about your measure 🙂

Eric.