cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
he203234
New Member

Matrix measure per sub categories

Hi Everyone,

 

I have Main Categories, Categories and Sub Categories (all sitting in dim tables)

 

I need it to look like that in matrix:

 

I tried this measure but it's not doing what I want ( I need to see all categories even if it's 0):

InDeptperCat =
CALCULATE(SUMX(EDCurrentPatients,EDCurrentPatients[InDept]),ALLEXCEPT(EDCurrentPatients,EDCurrentPatients[LT Sub Categories]))
Also, it keep repeating sub catecories on a mesure in every category for some reason. 
Thank you!
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

@he203234 
Would you please present some sample data of the four tables?

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

@he203234 
Would you please present some sample data of the four tables?

Helpful resources

Announcements
Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.