Multiple Rows in Matrix with Calculated Measure Problem

[PowerBI_newB23]

Help please

I have a Matrix visual with two row fields. The calculated measure below only works when I have one field and not two. Please assist

CALCULATE(DISTINCTCOUNT(Data_Load[Account_Number]), DATESMTD(Data_Load[Account_Open_Date]),Data_Load[Account_Open_Date])

Product_Code_Desc	Sub_Product_Desc	Sales MTD
Prod_1	sub_prod_1	586
Prod_1	sub_prod_2	1
Prod_1	sub_prod_3	44
Prod_1	sub_prod_4	40
Prod_1	sub_prod_5	5
Prod_1	sub_prod_6	1
Prod_1	sub_prod_7	1
Prod_1	sub_prod_8	25
Prod_1	sub_prod_9	2
Prod_1	sub_prod_10	2
Prod_1	sub_prod_11	3
Prod_1	sub_prod_12	1
Prod_1	sub_prod_13	10
Prod_1	sub_prod_14	361
Total		697
Prod_2	sub_prod_15	1
Prod_2	sub_prod_16	13
Prod_2	sub_prod_17	559
Prod_2	sub_prod_18	18
Prod_2	sub_prod_19	653
Prod_2	sub_prod_20	3
Prod_2	sub_prod_21	34
Prod_2	sub_prod_22	35
Prod_2	sub_prod_23	8869
		1268

@dax @NewB 

[PowerBI_newB23]

any idea @Greg_Deckler please

[Greg_Deckler · Accepted solution]

Seems like there is some missing information here. Like a date table, some relationships to the date table, etc.

Is that source data you present and what is the measure name for the formula you provided?

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