Forum Discussion
drill trough setup with measure fields
I have 3 measure fields I created that contain SUMX logic with return a count value . I returned the count of the measure fields in a stacked column chart. How do i set up the fields for drill through so I can see the associated records in my detail table? Ive added the fields to the drillthrough page, but when I right click on the visual, it returns all records in the sheet not just the records the measure fields represent. See screenshots below. Any help is appreciated. Thanks.
Hi jmitch3062
It happens because we cannot filter drill through by measure.
It needs row context.
You need to create the type of "measures table" and dynamic measure to manipulate a calculation.
please see the following discussion with an example:
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
In order to make it easier to understand, I also prepared another example that is more similar to the one you provided
Here is a link for my example
If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklyNo matter what logic the metrics you exchange between them have, the method will still work.
The same goes for names.
The only difference is that instead of individual measures, you "put " them in a table
3 Replies
Hi jmitch3062
It happens because we cannot filter drill through by measure.
It needs row context.
You need to create the type of "measures table" and dynamic measure to manipulate a calculation.
please see the following discussion with an example:
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
In order to make it easier to understand, I also prepared another example that is more similar to the one you provided
Here is a link for my example
If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklyok , in my case my measures are the results of some SUMX logic. Would those fields equate to your blackP, greenP, redP fields? These new measures are created in the same table as my current measure fields correct? Where you have color I would have a field called for example MY_measure_type, and this field would be different measures i want to reference , ex Incl5_Incl8, Only_Incl5, Only_Incl8 ?
No matter what logic the metrics you exchange between them have, the method will still work.
The same goes for names.
The only difference is that instead of individual measures, you "put " them in a table