Forum Discussion
Matrix including more entries from Rows which it should not as per filters applied
Hi,
I am currently using the Matrix Visualization, on there I have a field called Customer in the Rows section and one field called Available Days in Values.
In my Filter Pane I have the following fields with the values in Bold that I have applied the filter to the Page:
Year
2020
Month
Jun
Day
25
Person Name
John Smith
This will show the correct Customers in the Matrix Visualization, but when I add a new field called SLA % to the Values section the Customers increase and is showing Customers where John Smith has not made any Visits for that day? How do I just only show the Customers as per before I added the SLA % measurement, below is the DAX formulas for each Values:
Rows
Customer
Columns
Thanks
3 Replies
- AvPowerBI
Post Patron
Hi parry2k
Thanks for the reply.
The following link is has the Power BI document, you will see on there that Customers are showing even though that Person has not made any visits for that Customer
https://1drv.ms/u/s!Aknl2UdxdHn0dSh_iUKfuKOmRRo?e=Bmxbcc
Thanks
- AvPowerBI
Post Patron
Anyone out there that can help?