I created a measure to get a distinct count of customer master records with no credit limit.
Unique Customers without Credit Limit = CALCULATE(DISTINCTCOUNT(CUST_CREDIT_LIMIT[CUSTOMER_NUMBER]), FILTER('CUST_CREDIT_LIMIT', [CUSTOMER_CREDIT_LIMIT]<=0 ))
However, when I click a bar on the bar chart... it doesn't filter the table below in order to ONLY show those customers with zero credit limit.
Any help would be greatly appreciated.
Thanks for your responses. Yes, I made sure the interactions are setup to filter the table from the bar chart. There is only a single data table so no joins needed. The only solution that has worked is creating a conditional column for "Credit Y/N" and adding a visual filter to the bar chart for the "N" records. It works for now, but is a temporary fix for times' sake. This issue still bothers me though, because I haven't encountered this issue with my other PBI projects, and I don't know what the root cause is. For that reason, I'm leaving this issue as unresolved.
Perhaps you can share a pbix file with some dummy data and we can do test to troubleshoot on it. It is hard to test,reproduce and confirm where issue is without any same data.
Did you "hover the cursor over the funnel icon above the table to see if the filters are affecting the visual."?
I suspect the 2nd part of my answer is what's happening i.e. the table is being filtered but not in the way you expect (probably by region)
According to your snapshot, it seems like your filter not correctly apply and interact with your measure formals so that the formula cant gets the current row content value to filter and get dynamic results.
Please share more detailed information on your relationship mapping and double-check on the visualization interactions to confirm if they not setting correctly.
@cprine , I can see all amounts in the table visual are the same. I doubt there is a cross join or measure formula uses all.
Either correct the join or formula.
Also, check the visual are interacting with each other https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
The first thing to check is to hover the cursor over the funnel icon above the table to see if the filters are affecting the visual.
If the 'edit interactions' are all set up correctly, the filter may not be doing what you expect i.e. you've got a distinct count and a region but that doesn't include the customer numbers
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.