Forum Discussion
Assistance Required - Power BI Visual Matrix
Hi Tejas
Ok, great to hear that there is some progress. I took another look to see if I could get rid of the empty columns . I could only find a solution in Power Query and this was the result :
In general the steps taken are as follows : Identifies the Maxmonth and two months before ( Query : MaxMonthQuery ) , which joins with the Grouped average per assignment group ( Query : GroupedAverageQuery ) . This then finally joins with the MaindataQuery ( filtered to show only 3 months prior to max date of the data ) to merge the average SLA% per group.
For the updated file see the same folder I placed the other Power BI files in.
Hope this helps
Antonio
Lakhani04 Hey,
I will create below measure . I am assume that you these measure SLA met and total case as measure based on that SLA % 3months is getting calculated.
SLA % Last 3 Months =
VAR MaxDateInModel = CALCULATE(MAX('Date'[Date]), ALL('Date'))
VAR StartDate = EDATE(MaxDateInModel, -2) -- last 3 months: includes current month and previous 2 months
// Filter for last 3 months ignoring slicers on Month and Year
VAR Last3MonthsDates =
FILTER(
ALL('Date'),
'Date'[Date] >= StartDate
&& 'Date'[Date] <= MaxDateInModel
)
// Calculate sums within last 3 months, ignoring month/year slicers but respecting row context (grouping)
VAR MetSLA3M =
CALCULATE(
SUM('SLAData'[Met SLA]),
KEEPFILTERS(Last3MonthsDates)
)
VAR TotalCases3M =
CALCULATE(
SUM('SLAData'[Total Cases]),
KEEPFILTERS(Last3MonthsDates)
)
RETURN
DIVIDE(MetSLA3M, TotalCases3M, 0)
Thanks
Harish M
Kindly give kudos and accepts it as solution as if its resolve your problem
No didnt work.
