Forum Discussion

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost Patron
6 years ago

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

Available Days = CALCULATE(SUM(PersonCalendar[Avail Day Flag]), CROSSFILTER(PersonCalendar[PersonIdKey], Visits[PersonIdKey], Both))

 

SLA % = 1-DIVIDE(CALCULATE(SUM(Visits[Fix Exception Flag]),Visits[Call Type]="COMPLETED",Visits[Visit Fix Flag]=1),SUM(Visits[Visit Fix Flag]))

 

Thanks

 

3 Replies