Forum Discussion

PaulPalkowski's avatar
PaulPalkowski
Icon for Helper II rankHelper II
2 years ago
Solved

Matrix Column Sum

I have a very simple table from excel Animal Food Tiger Fish Elephant Veggies Bear Fish Monkey   Tiger Combo Elephant Fish Bear   Monkey Veggies Tiger   Be...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    PaulPalkowski,

     

    Try this measure:

     

    DC-Animals =
SUMX (
    SUMMARIZE ( Sample2, Sample2[Animal], Sample2[Food] ),
    CALCULATE ( DISTINCTCOUNTNOBLANK ( Sample2[Animal] ) )
)

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

PaulPalkowski,

 

Try this measure:

 

DC-Animals =
SUMX (
    SUMMARIZE ( Sample2, Sample2[Animal], Sample2[Food] ),
    CALCULATE ( DISTINCTCOUNTNOBLANK ( Sample2[Animal] ) )
)

 

 

PaulPalkowski's avatar
PaulPalkowski
Icon for Helper II rankHelper II
2 years ago

Perfect!!