Matrix Table with QTD YTD by Product

[ringovski]

Hi All,

I need to have QTR & YTD as columns in a Matrix table with the rows being country>products. 

Current Matrix Table

Year Country_Code	2021   Value$	2022   Value$
USA
code100	1328967	12888454
code101	84353905	27880729
code102	41839	230237
Total	85724711	40999420
UK
code100	1378967	82888454
code101	94353905	87880729
code102	91839	130237
Total	85724711	40999420

Desired Matrix Table

Year Country_Code	2021   Value$	2022   Value$	Jan-Feb 2022 QTR	Jan-Feb 2023 QTR	2023 YTD
USA
code100	1328967	12888454
code101	84353905	27880729
code102	41839	230237
Total	85724711	40999420
UK
code100	1328967	12888454
code101	94353905	87880729
code102	91839	130237
Total	85724711	40999420

Theres one fact table Export_Fact_Codes with Dimension for each SK Dim_Country, Dim_Product etc.. and a date_date (dates, month,QtrText,Quarter,ShortNameMonth )

Fact Table name Export_Fact_Codes_All
calendar_sk	country_sk	loading_sk	discharge_sk	product_code_sk	state_sk	quantity_sk	value
300	100	1	600	121	1	400	1 328967
300	101	1	601	121	2	600	84353905
300	102	2	603	121	2	800	41839
301	100	1	600	121	2	900	12888454
301	101	2	601	121	3	1000	27880729
301	102	2	602	121	3	200	230237

I have created the relevant measures;

SumValue = Sum(Export_Fact_Codes_All[value])

QTRValue = TOTALQTD([SumValues],Date_Table[Dates])

YTDValue = TOTALYTD([SumValues],Date_Table[Dates])

However when I try adding the measures to matrix with only the conutry & products I get blanks, then if I change the rows date then I get numbers. Obviously this is not what is needed.

Any help would be appreicated.

Thanks

[amitchandak · Accepted solution]

@ringovski , it seems like you are looking for Hybrid display

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc