How to divide two columns (periods) on a matrix visualization?

[jacobocruz]

On the Data Set Years are in the same column but I want it separated when creating the visualization and need to divide 2020/2019=%

Thanks

[v-yingjl]

Hi @jacobocruz ,

I have created a sample table like this and a measure if I got it correctly:

Create a Matrix like this:

Create a measure by this formula:

Measure = 
VAR _group =
    SELECTEDVALUE ( 'Table'[Group] )
VAR _2020 =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        'Table'[Year] = "2020",
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    )
VAR _2019 =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        'Table'[Year] = "2019",
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    )
RETURN
    IF ( _group <> BLANK (), DIVIDE ( _2020, _2019, BLANK () ), BLANK () )

Put this measure in a card visual, create a group slicer to get the divide value 2020/2019:

My sample file is attached that hopes to help you, please check and try it: 

How to divide two columns (periods) on a matrix visualization.pbix 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.