Forum Discussion

PBIDevNoob's avatar
PBIDevNoob
Helper I
6 years ago
Solved

Relationships and Reference Measure vs Direct Formula

Hi!    I'm trying to understand why my relationships doesn't seem to be working correctly and the difference between calling a measure from another measure and directly applying the formula in a me...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Try using DISTINCT instead of VALUES. VALUES and VALUE aren't the greatest functions in the world and tend to be overused. They tend to mask data modeling issues.

 

  • PBIDevNoob's avatar
    PBIDevNoob
    Helper I
    6 years ago

    Thanks, but it pretty much returns the same thing. I'm also more concerned with knowing why the relationship isn't working correctly and why the using a measure in a measure returns a different value than using the same formula directly. 

     

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      6 years ago

      PBIDevNoob 

       

      Every measure has an implicit CALCULATE that you can’t see, so measures always trigger context transition from within a row context. Besides, you may try performance analyzer in Power BI Desktop to check query.