Can someone please help me with this? I thought i understood this concept but cannot seem to put together the correct expression.
I am trying to aggregate the sum value of well cost in table ‘wvjobprogramphase’ for every well that is listed in table ‘wvwellheader’. I then want to iterate across the wvwellheader table so that I can calculate either the percentile or median value of all of the previous aggregates and want to display this value in the sub-total or card. I have nested a couple iterators while using the values() function but it appears that an average value is being displayed instead. Attached i have a scrubbed PBIX file and a screenshot of the final value.
Thanks in advance!
PBIscrub.pbix (102.2 KB)