Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create custom DAX table with x rows and y columns and cells are previously created Measures

Hi Everyone,

I am trying to create a DAX table with 7 rows and 12 columns and each cells inside are previously created different measures. 
Please let me know if this is possible and how can we acheive this. I am new to DAX and any help would be appreciated.

Many thanks,
Midhun

4 REPLIES 4
az38
Community Champion
Community Champion

Hi @Anonymous 

Please, visualize your input and desired output data 🙂

 

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Hi @az38 ,

Thanks a lot for getting back to be.

I hope the below helps:
This is the Output I am looking for. Each rows are calculated from different data sets. Say, to calculate Starting value, I have a measure between two tables. Same for all the rows. 

Currently I have created a visual similar to the below using KPI cards showing each measure. But this is causing Power Bi web service to load very slow.
I was wondering If I could manage to create a DAX table with each of the mesuare as cells exactly as shown in the below stucture may be it will help. 

Capture.PNG

 
 

 

 

 

 

 

Hope this gives you an idea. Please let me know if you need any more information.

Thanks a lot,
Midhun

az38
Community Champion
Community Champion

Well, @

I think the best option is to use Matrix visual.

Use Date hierarchy as columns and Measures as values

 

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Hi @az38 ,

Thanks, let me try that, Cheers!
Also, then I may need to slipt this into two Matrix on for sales and one for profit. 

Is it possible to call mesuares as cells in a DAX table?

Thank you for your time.

Many thanks,

Midhun

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors