Hi there, I am trying to replicate an existing report visual in PowerBI and I'm not sure how to accomplish it. The matric visual appears to be my best bet but I'm struggling to understand how tocalculate the feature using the correct formula in PowerBI Desktop (May 2024 edition).include the feature in the visualI'm not sure how to explain it so a sample might be the best. The input is very basic and you could presume its originally sourced from a table of transactions which is then aggregated by item sold,repaired, recycled over year end and regions. In the desired output the % New Market is the value New Market as a percentage of the total across the region. The matrix visual allows me to add a row total but I'd like to instead include the calculation. I have created measures for the items sold, repaired, recycled and included them on the values section of the matrix visual. Year and Region are dimensions on the rows section. How do I calculate the formula (measure, calc column, something else) and where do I add it to the visual?Sample InputYear EndRegionItems SoldItems RepairedItems Recycled2020New Market4183524122020Established6063681412020Home6414073882021New Market1463955982021Established1333591482021Home4141395072022New Market2144982702022Established3163794442022Home1406483472023New Market2221366292023Established4831323732023Home1683954672024New Market3473021902024Established5284333022024Home536497224 Desired OutputYear EndRegionItems SoldItems RepairedItems Recycled2020New Market4183524122020Established6063681412020Home641407388 % New Market25%31%44%2021New Market1463955982021Established1333591482021Home414139507 % New Market21%44%48%2022New Market2144982702022Established3163794442022Home140648347 % New Market32%33%25%2023New Market2221366292023Established4831323732023Home168395467 % New Market25%21%43%2024New Market3473021902024Established5284333022024Home536497224 % New Market25%25%27%

I was able to get something close to your dsired output: This is using a matrix visual, three measures for your columns, and an additional measure to capture reusable dynamic formatting string: Items Recycled_Subtotal% = VAR _sum = SUM( 'Table'[Items Recycled] ) VAR _sumNewMarketOnly = CALCULATE( SUM( 'Table'[Items Recycled] ), TREATAS( { "New Market" }, 'Table'[Region] ) ) RETURN IF( ISFILTERED( 'Table'[Region] ), _sum, DIVIDE( _sumNewMarketOnly, _sum ) ) Items Repaired_Subtotal% = VAR _sum = SUM( 'Table'[Items Repaired] ) VAR _sumNewMarketOnly = CALCULATE( SUM( 'Table'[Items Repaired] ), TREATAS( { "New Market" }, 'Table'[Region] ) ) RETURN IF( ISFILTERED( 'Table'[Region] ), _sum, DIVIDE( _sumNewMarketOnly, _sum ) ) Items Sold_Subtotal% = VAR _sum = SUM( 'Table'[Items Sold] ) VAR _sumNewMarketOnly = CALCULATE( SUM( 'Table'[Items Sold] ), TREATAS( { "New Market" }, 'Table'[Region] ) ) RETURN IF( ISFILTERED( 'Table'[Region] ), _sum, DIVIDE( _sumNewMarketOnly, _sum ) ) Dynamic Format = IF( ISFILTERED( 'Table'[Region] ), "0", "0%" ) For each of the measures (not including [Dynamic Format]), set the format to Dynamic, and put [Dynamic Format] in the Format bar: Here are the steps to update the matrix visual's formatting to match what I have at the top. 1) Add in Table[Year End] and Table[Region] to Rows and the three measures (Items Recycled_Subtotal%, Items Repaired_Subtotal%, Items Sold_Subtotal%) 2) Rename the measures so they match the columns they are based on 3) Change in Format visual > Visual > Layout and style presets:Layout: TabularRepeat row headers: On 4) Change in Format visual > Visual > Blank rows:Blank rows: OnBlank rows > Border: On 5) Change in Format visual > Visual > Row headers:+/- icons: Off 6) Change Format visual > Visual > Row subtotals > Per row level: On6a) For Row level: RegionSubtotal label: % New Market6b) For Row level: Year EndShow subtotal: OffNote: this removes the "extra" Total row at very bottom

Adding Custom formula to Matrix visual | Microsoft Fabric Community

Forum Discussion

Related content

Adding custom visual without data mapping

If formula

formula

DAX Formula Help

Build custom HTML with formula