Measure required in Power BI matrix

hI PaisleyPrince 

The following measure should return what you want:

This is the measure I created:

Week % of Month =
VAR CurrentVolume = SUM('Table'[Volume])

VAR MonthTotal =
CALCULATE(
SUM('Table'[Volume]),
REMOVEFILTERS('Table'[Week No])
)

RETURN
DIVIDE(CurrentVolume, MonthTotal)

Hi PaisleyPrince 

Please check and confirm with headsup. Thank You!

Week % of Month =
VAR WeekVolume =
SUM ( Fact[volume] )

VAR MonthVolume =
CALCULATE (
SUM ( Fact[volume] ),
REMOVEFILTERS ( 'Date'[Week No] )
)

RETURN
DIVIDE ( WeekVolume, MonthVolume )

Hi PaisleyPrince ,

Please try below visual calculation(select your Matrix visual and click new visual calculation) in your matrix:

Percent of parent = FORMAT(
DIVIDE(
    [Sum of Volume]
,
COLLAPSE([Sum of Volume],ROWS,1)

),"0.00%")

Sample PBIX

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

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 ?

Please check the formula below:

Week %  =
DIVIDE(
    [Volume],
    CALCULATE(
        [Volume],
        REMOVEFILTERS('Date'[WeekNo])
    )
)

Hi PaisleyPrince,

Assuming you already have a measure for Sales (or similar), you can create a new measure for Week % of Month:

Week % of Month =
DIVIDE(
    [Total Sales],  // numerator: sales for the current week
    CALCULATE(
        [Total Sales],
        REMOVEFILTERS('Date'[Week]),       // remove week filter
        KEEPFILTERS(VALUES('Date'[Month])) // keep current month context
    ),
    0
)

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

Hi,

Try this measure

Total of month = calculate([Volume],allexcept(calendar,calendar[month]))

Week % = divide([Volume],[Total of month])

I have assumed that volume is an explicit measure.

Hi PaisleyPrince 

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