Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |