Drill-Through Page Not Filtering Correctly on DAX Measures
Dear Community I'm having trouble getting the correct related data to display in my drill-through. When I hover over the drill-through button on my bar chart, it's showing the entire table instead of filtering to the specific data. I've added the drill-through field for all the relevant DAX measures, but it's not producing the expected results. Can anyone suggest how to fix this issue? Any help would be greatly appreciated! PBIX File attached PBIX File Many ThanksDrill through without selecting any visual element or after selecting multiple!
Hey! I managed to create a way to drill through to multiple pages without having the user obliged to select a particular element in a visual, or with the user selecting multiple elements from multiple visuals. Assume you have your drill though pages, say names page1 till page4, and you have your report home page summarizeg your data. Normally to drill through from home page to any page, you have to right click on a visual element, exactly one, then choose the page you want to go to. Alternatively, you can add in your fact table a calculated column, named "Drill" with a constant value, say =1. Now you can add this column to a card visual (the new card visual), disable the value, and type "Right click to drill through" in the value label, or any other text you see suitable. This will do the job! You can also use the pie chart visual and put the Drill column in the values and legend (to be able to choose a color) and enable drill through on click from the format menue (not right click). It worked on PBI desktop, but unfortunately when I published the report, did not work on the service! Two comments here: you can zero the paddings and shrink the pie chart to a button size. Also make sure in the values aggregation you choose min, max or average, but never use sum or count, because as you choose elements from other visuals, the pie size will shrink 😄. You can also use a treemap if you want a rectangular shape. Hope this helps someone 🙂
Create a measure which by can bypass the filter brought from drill through
Hello everyone, I've designed a detailed page to display ticket statuses, specifically "success" and "failed." One of the critical metrics on this page is the percentage of failed tickets. Currently, the setup involves navigating from an overview page by right-clicking and drilling through a pie chart to select the "failed" section. This brings only "failed" tickets to the detail page, causing the denominator for calculating the percentage to consider only failed tickets. What I'm looking to achieve is to have both "success" and "failed" tickets in the calculation. I've attempted to use functions like "removefilter" and "allselected" in the calculation, but I'm encountering issues where it either shows only failed tickets or all tickets without responding to date selection. I'd greatly appreciate some guidance on how to address this issue. best regards, WVisualization Not working as needed with dax measure
Visualization drill down not showing. I can only drill through the non-compliant data and not the compliant ones. I have created a formula to check how much data is compliant and non-compliant. For example, if the customer has all the fields populated then he is compliant, so their details are missing from the Query1 table. If the member has a missing information, then he is non-compliant and will be available in the query table. Compliant Formula = DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1)) Non-Compliant= 1- ( DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1))) I have also created a calculated column in the member table to check if I can showcase both compliance and Non-compliance data but that is also not working Compliance Check = IF( COUNTROWS( FILTER( Query1, Query1[MemberNum] = 'DW v_Member'[MemberNum] ) ) > 0, "Non Compliant", "Compliant" ) Table information : Dw_Member: is a fact table with all customer information Branch is a fact table with all of company branches Date table Query 1 comprises of only those customers whose profile has a missing information for example date of birth or address etc. A customer can appear more than once if they have multiple information missing Donut chart appears correctly with compliant and non-compliant measures but all other measures are not getting drilled through see second chartHow to keep filter on category but remove it on # of units within category?
Hi there, I have a report that analyzes how much we've spent on third-party vendors. We have 26 different vendor categories that the vendors can fall under. I'm having issues with displaying the average category cost over a single year on a line chart on a drill through page. When a user drills in on a single vendor, the line chart is supposed to show the average amount spent within that selected vendor's category over a singler year (so the average would include total spent within that category divided by the number of vendors within that category). At the bottom is the formula used to determine the average category total, but this becomes challenging when a user drills in on a vendor. When they drill in, it filters on the vendor and then on the vendor's category. So the average category total runs as if there's only one vendor in that category, which is obviously incorrect. Question: How can I keep the filter on the vendor category, but remove the filter on the number of vendors in that category? For example, looking at the screenshot below, if I drill in on Vendor 1, how can I keep the filter on the category "Trading System" and still have the number of vendors be 7? Would I apply ALL or KEEP/REMOVEFILTERS somewhere in the formula below? Again, note that this information would be displayed in a line chart, not in a matrix. Category Average = VAR NumVendors = COUNTROWS(DISTINCT('Vendor Invoices_Master'[Vendor Reporting Name])) VAR SumInvoice = SUM('Vendor Invoices_Master'[Invoice Amount]) VAR TotalAvg = DIVIDE(SumInvoice, NumVendors) VAR _Table = ADDCOLUMNS( SUMMARIZE( 'Vendor Invoices_Master', 'Vendor Invoices_Master'[Vendor Category]), "_NumVendors", NumVendors, "_SumInvoice", SumInvoice, "_Average", TotalAvg ) VAR Result = AVERAGEX(_Table, TotalAvg) RETURN Result
Drill Through Button - Multipe Pages
Please assist? I created a drill through button(page 3) to drill from the Cart "Invoices Paid On time if posted on time" to it's detail page. Can u use this one drill through button to drill through mutple pages(all the invoice carts on page 3) Or must i create a drill button for each of the invoices? https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing
