cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Duffy_Ibru Frequent Visitor
Frequent Visitor

Urgent Support for matrix table

Please i am new to dax functions.  i am trying to achive the below template reports on powerbi. 

 

I Have done calculated colums for LG,Samsung and nexus seperately. that is to say i have the sum of each product posted to my chart of accounts.  

 

However i do not know how to return the qualitative aspect of my template, which is revenue, haulage etc for each of the product.

 

This is my dax;

 

LG = (CALCULATE(SUM('General Ledger Entries'[Amount]),FILTER('Chart of Account',' Chart of Account'[No]=5000100))

 LGSAMSUNGNEXUSTOTAL
 NGN'000NGN'000NGN'000NGN'000
Revenue                           20,000 65,00020,000105,000
Actual cost of goods sold                             (1)                                 -                               (0)                          (1)
Other export cost                      31,654                         (31,654)                           (0)
Haulage                             (0)                             -                            (0)
Freight on export sales                             (0)                                 -                             (0)
Gross profit / (loss)                      31,653-31,654                             (0)                          (1)
    0
SALES MIX (%)57.14%14.29%28.57%100.00%
     
GROSS PROFIT/(LOSS) RATIO==>> -791324775.00%3165400100.00%0.00%14485.71%
4 REPLIES 4
Duffy_Ibru Frequent Visitor
Frequent Visitor

Urgent support for matrix table

Please i am new to dax functions.  i am trying to achive the below template reports on powerbi. 

 

I Have done calculated colums for LG,Samsung and nexus seperately. that is to say i have the sum of each product posted to my chart of accounts.  

 

However i do not know how to return the qualitative aspect of my template, which is revenue, haulage etc for each of the product.

 

This is my dax;

 

LG = (CALCULATE(SUM('General Ledger Entries'[Amount]),FILTER('Chart of Account',' Chart of Account'[No]=5000100))

 LGSAMSUNGNEXUSTOTAL
 NGN'000NGN'000NGN'000NGN'000
Revenue                           20,000 65,00020,000105,000
Actual cost of goods sold                             (1)                                 -                               (0)                          (1)
Other export cost                      31,654                         (31,654)                           (0)
Haulage                             (0)                             -                            (0)
Freight on export sales                             (0)                                 -                             (0)
Gross profit / (loss)                      31,653-31,654                             (0)                          (1)
    0
SALES MIX (%)57.14%14.29%28.57%100.00%
     
GROSS PROFIT/(LOSS) RATIO==>> -791324775.00%3165400100.00%0.00%14485.71%
Phil_Seamark Super Contributor
Super Contributor

Re: Urgent Support for matrix table

Hi @Duffy_Ibru

 

We probably need to learn a little more about your data model.

 

YOu say you don't know how to do Revenue for LG, but your sample set of data shows 20,000.  Is this wrong?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Duffy_Ibru Frequent Visitor
Frequent Visitor

Re: Urgent Support for matrix table

yes u re correct.  i have done calculated colums to return the value of each of my products. 

 

i select the matrix visual and put each calcuted column on column 

 

Revenue LGRevenue Samsung Revenue Nexus Freight LG Freight SamsungFreight Nexus
     20,000.00                    65,000.00              20,000.00   10,000.00               20,000.00            5,000.00

 

 

However, i want the visual to appear like this;

 

 

 LGSamsungNexus Total 
Revenue                    20,000.00              65,000.00   20,000.00            105,000.00
Freight                     10,000.00              20,000.00     5,000.00               35,000.00

 

 

 

Super User
Super User

Re: Urgent support for matrix table

Hi @Duffy_Ibru,

 

Can you give some further details or example of your data? To help you bettwe without further information is difficult.

 

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 118 members 1,903 guests
Please welcome our newest community members: