cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teckchan Helper I
Helper I

Building a table/Matrix with calculated rows

Hi,
I am trying to build a matrix/table with some calulated rows and the columns are geographic locations. It should look like this...funnel.PNG 

I have a table with org id, assigned units, provisioned units,geo_locations, contract start & end dates. Accounts purchased is the distinct count of org id. I have to create measures to calclulate assigned % (assigned % = assigned/provisioned). Its bascially a funnel. How do i go about this? 
Thank you!

4 REPLIES 4
JosefPrakljacic Solution Sage
Solution Sage

Re: Building a table/Matrix with calculated rows

Hello Teckchan,

it's no shame to provide sample data. Your question could answered quickly if you have sample data, otherwise the person who wants to help you wastes a lot of time building a sample record that may not match your Use Case.

Therefore I may ask you to attach sample data or your PowerBI file.

Here's a description of how to get questions answered quickly in this forum. 

 

BR,

Josef

Community Support
Community Support

Re: Building a table/Matrix with calculated rows

Hi @teckchan ,

 

Can you provide some sample data and tell us what you want? And based on my understanding, you can refer to this post first:

Combine measures in Matrix visual and calculate variance by date and period.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

teckchan Helper I
Helper I

Re: Building a table/Matrix with calculated rows

Hey @JosefPrakljacic and @Icey ,
Sure thing. PFA some sample data. Thanking you in advance!

org_idorg_namegeoregion_descriptioncontract_start_datecontract_end_dateprovisioned_seatsassigned_seatstotal_downloadersas_of_date
0AADD36B545A8EF50A4CBrainloungeAmericasNorth America2019-08-152021-08-15650613402019-08-30
0AADD36B545A8EF50A4CJumpXSAmericasNorth America2019-08-152021-08-15650618432019-09-06
0AADD36B545A8EF50A4CBabblesetAmericasNorth America2019-08-152021-08-15650624462019-09-13
0AADD36B545A8EF50A4C98A7InnotypeJapanNorth America2019-08-152021-08-15650625392019-08-16
0AADD36B545A8EF50A4C98A7ZoomcastAmericasNorth America2019-08-152021-08-15650630402019-08-23
0AADD36B545A8EF50A4C98A7RiffwireAmericasNorth America2019-08-152021-08-15650632502019-09-20
0F4FC703547E3FA50A4C98A1FeedspanEMEASouthwest Europe2019-08-012021-08-1517002019-08-30
0F4FC703547E3FA50A4CMydoEMEASouthwest Europe2019-08-012022-08-01170NULL2019-09-06
0F4FC703547E3FA50A4C98A1TanoodleAsiaSouthwest Europe2019-08-012022-08-01170NULL2019-09-13
0F4FC703547E3FA50A4C98A1BrainloungeEMEASouthwest Europe2019-08-012022-08-01170NULL2019-09-20
0F4FC703547E3FA50A4C98A1ZavaEMEASouthwest Europe2019-08-012022-08-0117002019-08-02
0F4FC703547E3FA50A4C98A1QuimmEMEASouthwest Europe2019-08-012022-08-0117002019-08-09
0F4FC703547E3FA50A4C98A1BabbleblabAsiaSouthwest Europe2019-08-012022-08-0117002019-08-16
0F4FC703547E3FA50A4C98A1PhotobugEMEASouthwest Europe2019-08-012022-08-0117002019-08-23
1021C703547E43280A4C98A1BabbleblabAsiaSouthwest Europe2019-06-302022-06-30526202019-07-05
1021C703547E43280A4C98A1SkipstormAsiaSouthwest Europe2019-06-302022-06-30526452372019-07-12
1021C703547E43280A4C98A1JabbercubeEMEASouthwest Europe2019-06-302022-06-30526524482019-07-19
1021C703547E43280A4C98A1RealfireEMEASouthwest Europe2019-06-302022-06-30526535512019-07-26
1021C703547E43280A4C98A1ZoozzyJapanSouthwest Europe2019-06-302022-06-30526535522019-08-02
1021C703547E43280A4C98A1YakitriEMEASouthwest Europe2019-06-302022-06-30526536522019-08-09
JosefPrakljacic Solution Sage
Solution Sage

Re: Building a table/Matrix with calculated rows

Hello techkan,

 

your example is not enough. I'm not sure how this sample data matches the lines from your screenshot (Accounts Purchased, Under 30 Days into Contract).

Nevertheless, to add these rows you will need to create a "helper table".

 

Here is a guide on how to do this in order to achieve your expected result. 

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors