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 )

     

     

     

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
8 months ago

Hi PaisleyPrince 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    8 months ago

    Hi PaisleyPrince 

    Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.