Forum Discussion

DavePowerBI's avatar
DavePowerBI
Frequent Visitor
3 years ago
Solved

Matrix measure between two tables common value includes multi Slicers

Hi all I am a newbie and I need some help with a division calculating on the same country between two tables which includes multi values selected via slicers   I have two tables which have a relat...
  • TomasAndersson's avatar
    3 years ago

    Hi!
    It sounds like you should get your result using just a few measures. I'm not exactly sure how your March Retail table is structured so you might have to adjust accordingly, but something like this.

    Sum of Sale Count := 
    SUM('March Birthday'[Sale Count])
    
    Sum of Sale Country Total := 
    SUM('MarchCountry Total'[Sale Country Total])
    
    Sale Count divided by Sale Country Total :=
    DIVIDE(Sum of Sale Count, Sum of Sale Country Total)

     
    This is using three separate measures. You could do everything in a single measure, but it's usually considered good practice to create separate measures for basic measures such as "Sum of..." since they often can be reused in several other measures.

     

    Hope this helps!