Forum Discussion
drill trough setup with measure fields
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
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 quickly
ok , 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