Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
3 years ago

How to include Total Measure by Categories from Another Table into SummarizedColumns

Hi,

 

Need some help into create Summarized column table; 

 

As you can see I have two different table for Gender Table A and B, and each have different Measures call "Total+" and "Pop".

I would like to create Summarized table as you can see in screen shot for Summarized table.

 

What I am getting is like this; as you can see Pop number is total of both. 

 

This is what I have writted for Summarizedcolumns:

 

SummarizedColumns('Table A'[G], "total +",[Total Positive],"Pop", 'Table B' [Total Pop])

 

Thanks

Need Help

7 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    We are not in a art class. Please create with the forum table function some good example 🙂

      • andhiii079845's avatar
        andhiii079845
        Solution Sage
        3 years ago

        I would create a third table with one column of the both table and use this new column to calculate both measure. 

        gender
        m
        f
  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    I try it:

    Measure = 
    SWITCH(SELECTEDVALUE(Dim[Categorie]),"F",CALCULATE(sum('Fact'[Sum]),FILTER('Fact','Fact'[Gender]="F")))

    With the "main group" (gender, age group) you would able to optimize your dax code like:

     

    Measure = 
    SWITCH(SELECTEDVALUE(Dim[Main]),"Gender",CALCULATE(sum('Fact'[Sum]),FILTER('Fact','Fact'[Gender]=SELECTEDVALUE(Dim[Categorie]))))