Forum Discussion

shalnark0727's avatar
shalnark0727
Frequent Visitor
7 years ago
Solved

PowerBI Matrix

I'm new in power bi and in need of help on how I can do this in matrix. I need a produce these on thousands of data but in simple terms my table looks like the following   Table1 Date Product ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi shalnark0727,

     

    Create a calendar table and Products table and make a one to many relationship between these tables and the other two, then just create the following to measure to use on your matrix:

     

    Quota Total = SUM(Table2[Quota])

Sales Total = IF(SUM(Table2[Quota]) = BLANK();BLANK(); SUM(Table1[Sales]) + 0)

    Check PBIX file attach.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi shalnark0727,

 

Create a calendar table and Products table and make a one to many relationship between these tables and the other two, then just create the following to measure to use on your matrix:

 

Quota Total = SUM(Table2[Quota])

Sales Total = IF(SUM(Table2[Quota]) = BLANK();BLANK(); SUM(Table1[Sales]) + 0)

Check PBIX file attach.

 

Regards,

MFelix