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,
Most articles on this have suggested creating a calculated column to use for the column instead of using measures, but I have a matrix which needs to have individual measures but I was wondering if there is any workaround to apply the dax filters from the measures when drilling through to another page?
As the drillthrough currently ignores any dax filters used in the measure.
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
It is unavailable to put measure onto column box of Matrix visual and drillthrough by the measure in Power BI currently.
There are some Comparison between Calculated Columns and Calculated Measures.
Calculated Columns are:
Calculated Measures are:
You may refer to the links to learn more about column and measure:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/,
https://www.jetglobal.com/blog/calculated-columns-vs-measures/.
To work around the issue, you may need to convert the measure to calculated column first of all .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xicai ,
Thanks for your help. Though for what I was trying to created I really needed the Measures over the Calculated Columns. As such to create the illusion of drillthrough I created 4 versions of the same table/drillthrough page and applied the required filters on each page to mimic the calculation/filtering behind the 4 Measures and then hid each page. So when drilling through on each of the Measures the user goes to what looks like the same page, but depending on the Measure each drillthrough page is slightly different.
Thanks!
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @v-xicai ,
Thanks for your help. Though for what I was trying to created I really needed the Measures over the Calculated Columns. As such to create the illusion of drillthrough I created 4 versions of the same table/drillthrough page and applied the required filters on each page to mimic the calculation/filtering behind the 4 Measures and then hid each page. So when drilling through on each of the Measures the user goes to what looks like the same page, but depending on the Measure each drillthrough page is slightly different.
Thanks!
Hi @Anonymous
I would like to try you approach. (Multiple drillthrough pages and hid it)
But how do you make it so user dont have to choose which drillthrough page they want to go when they right click?
Hi @rubymaya ,
For my example I had to create different pages to drill through for each of the measures and apply the necessary page level filters.
I then just applied each measure to the respective page as a drill through field, so when the user right clicks on the measure in table only 1 option appears for them to drill through to.
I hope that helps 🙂
Hi @Anonymous ,
It is unavailable to put measure onto column box of Matrix visual and drillthrough by the measure in Power BI currently.
There are some Comparison between Calculated Columns and Calculated Measures.
Calculated Columns are:
Calculated Measures are:
You may refer to the links to learn more about column and measure:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/,
https://www.jetglobal.com/blog/calculated-columns-vs-measures/.
To work around the issue, you may need to convert the measure to calculated column first of all .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |