Forum Discussion

molinamelody's avatar
molinamelody
Frequent Visitor
5 years ago

Sum in Matrix visual with filters from multiple tables

I will try to put my question out again as there were some issues with posting when I updated it.
 
I am trying to sum data in a Matrix with filters from multiple tables and am unable to determine the correct measures to use. 
 
What I am looking is result similar to the below:
 

 

I am unable to share the pbix, below is a view of the four separate tables of data I import into Power BI:

 

 

 

The data structure and measures I have tried so far:

 

 

1) Count ECountry = Calculate(DistinctCOUNT(Sheet1[ECountry]),KEEPFILTERS(Sheet1))

2) Epic Size = Calculate(Sum('Sheet1 (4)'[ESize]), KEEPFILTERS(Sheet1),('Sheet1 (4)'))

3) Epic Size Alloc = Divide([Epic Size],(SUMX(Sheet1,Sheet1[Count ECountry])))

 

Any help with calculations or guidance on data structure is much appreciated!

 

Melody

DAX Calculation
DAX Filtering
Filter Multiple Column
keepfilters
Matrix Visual
No RepliesBe the first to reply