Forum Discussion

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
8 months ago
Solved

Measure required in Power BI matrix

Hi, I have a matrix showing values by weeks and months but i only want the week % to be shown as that related to the current month rather than the overall total as per the screenshot. Can you please...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    8 months ago

    Hi PaisleyPrince

     

    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 )

     

     

     

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
8 months ago

Hi,

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 ?

 

 

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

Please check the formula below:

 

Div1 % =
DIVIDE(
    [Inv Div1],
    CALCULATE( [Inv Div1], REMOVEFILTERS('Date'[WeekNo]) )
)

 

and use it for 2 and 3 by creating seperate measures.