Forum Discussion
Advocate IIMeasure required in Power BI matrix
Please check and confirm
Base measure
Total Invoice Value :=
SUM ( FactInvoices[InvoiceValue] )
Final single % measure (use this in matrix)
Div Week % of Month :=
VAR MonthTotal =
CALCULATE (
[Total Invoice Value],
REMOVEFILTERS ( Date[WeekNo], FactInvoices[Division] )
)
RETURN
DIVIDE ( [Total Invoice Value], MonthTotal, 0 )
Advocate IIHi,
I have a matrix showing values by weeks and months invoice values by division but i want the division & week % to be shown as that related to the current month total rather than the overall total as per the screenshot. Can you please advise how this would be done ?
Super User
Please check and confirm
Base measure
Total Invoice Value :=
SUM ( FactInvoices[InvoiceValue] )
Final single % measure (use this in matrix)
Div Week % of Month :=
VAR MonthTotal =
CALCULATE (
[Total Invoice Value],
REMOVEFILTERS ( Date[WeekNo], FactInvoices[Division] )
)
RETURN
DIVIDE ( [Total Invoice Value], MonthTotal, 0 )