Forum Discussion
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...
Try this measure:
DC-Animals = SUMX ( SUMMARIZE ( Sample2, Sample2[Animal], Sample2[Food] ), CALCULATE ( DISTINCTCOUNTNOBLANK ( Sample2[Animal] ) ) )
Try this measure:
DC-Animals =
SUMX (
SUMMARIZE ( Sample2, Sample2[Animal], Sample2[Food] ),
CALCULATE ( DISTINCTCOUNTNOBLANK ( Sample2[Animal] ) )
)
Perfect!!