Forum Discussion

vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
8 years ago

Product and Average

Hi, 

 

Objective is to create below matrix in PBI. Need help with level 3 calculation.

 

Level 3, Avg Yield: Need help!

Level 2, Roll Yield: Achieve using New Table + Summarize column

Level 1, Yield: Achieve using measure

 

Fomula in Excel (Column J)

 

Sample Data (Actual data has >100k rows, multiple customers, families and stations)

CustomerFamilyStationPassCountTotalCount
ClassGroup1sub-grp11015
ClassGroup1sub-grp2512
ClassGroup2sub-grp3618
ClassGroup2sub-grp4713

Sample data

 

Need Help

9 Replies

  • vik0810's avatar
    vik0810
    Icon for Resolver V rankResolver V
    8 years ago

    Hi, I created a PBI file with your data and uploaded it here. The end result looks like this:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi vincentakatoh,

     

    Have you tried to use "Quick Measures" here you could for example make a measure where you simply click on multiplication and select the columns you want to calculate. After that you can calculate an average by using the AVERAGE function. or you can create it through a "Quick Measure" again.

     

    I was'nt entirely sure what you wanted to achieve so if I answered the wrong question please let me know :)

     

    Regards,

    L.Meijdam