A Calculation Group using a different kind of time intelligence

[Anonymous]

Hello, 

I am having issues getting some values to show. I poured through the web and found that calculation groups would be a better solution, but I am a begginer level at best when it comes to using DAX. I have Tabular Editor 2 as I can't pay for the newer one. 

Below I have my matrix visual, I want to add calculation items to display the values if that is possible. There are a ton of values that have to be shown. I have a parameter that is used to be able to select between the different values. The parameter was used in a measure that shows the last 13 week avg. I have the dax for it below. 

So im just wondering instead of creating this measure for L13W Avg (and since I will need another column called L13W vs LW % Chg) could I make a calculation items for the missing columns and if so how would I make it. 

ChatGPT has been only somewhat helpful. Its great making measures but not in directing me to make calculation group. Can anyone help?

edit: I really want to keep my parameters as we have around 20 values that have to be shown within the report. I just want to be able to show a L13W Avg and a % Chg from LW as values in the matrix. 

[lbendlin]

You are trying to make Power BI behave like Excel.  While it is technically possible to have custom matrix visuals with multiple independent totals it's a lot of maintenance effort, and you want to be really sure your needs justify that.

Consider instead using the standard Power BI functionality and splitting your visual into two visuals