Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerBI_newB23
Frequent Visitor

Multiple Rows in Matrix with Calculated Measure Problem

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_DescSub_Product_DescSales MTD
Prod_1sub_prod_1586
Prod_1sub_prod_21
Prod_1sub_prod_344
Prod_1sub_prod_440
Prod_1sub_prod_55
Prod_1sub_prod_61
Prod_1sub_prod_71
Prod_1sub_prod_825
Prod_1sub_prod_92
Prod_1sub_prod_102
Prod_1sub_prod_113
Prod_1sub_prod_121
Prod_1sub_prod_1310
Prod_1sub_prod_14361
Total 697
Prod_2sub_prod_151
Prod_2sub_prod_1613
Prod_2sub_prod_17559
Prod_2sub_prod_1818
Prod_2sub_prod_19653
Prod_2sub_prod_203
Prod_2sub_prod_2134
Prod_2sub_prod_2235
Prod_2sub_prod_238869
  1268
   

 

@dax @NewB 

1 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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
PowerBI_newB23
Frequent Visitor

any idea @Greg_Deckler please

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors