how to add columns in a dimension

[Anonymous]

Hi, experts, I have a problem in display some measures, here is the data:

but the visual should be like this, a summary of top 3 months should be added, and similiary the gap of sum(202201-202206）and sum(202207-202212) should be added in a column

so how to add such a summary value in rows of yearmonth column? Thank you.

[pi_eye]

Hi @Anonymous 

To display only months 1-3, and only add those up in a total, you can apply a filter to the measure

See table below:

Calc1,2 and 3 are:

calc1 = CALCULATE(sum(Sheet1[cal1]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203})  )

calc2 = CALCULATE(sum(Sheet1[cal2]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203})  )

calc3 = CALCULATE(sum(Sheet1[cal3]) ,filter(Sheet1,Sheet1[yearmonth]in{202201,202202,202203})  )

What did you mean by the gap of the sums? As an extra column in addition to the total?

Pi