Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Implicit vs explicit measures and records

Hi

 

I've watched a video saying that it is always recommended that one uses explicit meassures rather than implicit.

 

My problem is that when I use explicit measaures, I loose the ability to drill down to specific records. For example, assume that a table has

 

<customer>, <sales_value>

 

I do a pivot table to have the average_sales_value per customer using the <sales_value> field of the table, I can right click on each value and have the option to see the specific records that drive that value.

 

HOWEVER, if I define an explicit record i.e. AVG_sales_Value = AVERAGE([sales_value]) and drag that meassure in the pivot table, then the option "show records" is not available!!

 

Is there a solution for that? diging to specific records when analysing data is essential in order to understand outliers.

 

thank you in advance

 

 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Hmm, you are correct. What video were you watching? I'm guessing that it is a "best practice" because of one or two specific scenarios that probably aren't covered by what you are doing.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I'm referring to this one

       

      https://www.youtube.com/watch?v=A95nqPLdmRU&t=347s

       

      is there a way to be able to display records when using an explicit filter? There are cases when the meassure is more complicated and one can't get away with the implicit meassure