Forum Discussion

curtismob's avatar
curtismob
Helper IV
4 years ago

Using the First Value Of a Group

Hello, Below is what I am trying to accomplish. Use the cost for the first vendor in the grouping, where the "As Of" date selected falls w/in the Effective/Expiration range. Grouping is by Catego...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
4 years ago

Hi curtismob 

 

Please upload pbix file in google drive, make any one can access it and share the link here

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      4 years ago

      Hi curtismob ,

       

      Try to create a measure like below and apply it to visual level filter:

      Measure 2 =
var rank_ =
RANKX (
ALLEXCEPT( Cost,Cost[CostCode] ),
[Measure Cost AsOf]
)
var min_vendor = CALCULATE(MIN(Cost[VendorNo]),FILTER(ALLSELECTED(Cost),Cost[CostCode]=MAX(Cost[CostCode])))
return IF(rank_=1&&MAX(Cost[VendorNo])=min_vendor,1,0)

       

       

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

      • curtismob's avatar
        curtismob
        Helper IV
        4 years ago

        Hi V-lianl-msft,

        Thank you for the response, I'm not sure why I wasn't notified you reponded.  I will give this a try and update this thread.

         

        curtismob