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
Yurik74
Frequent Visitor

Star switch P&L report - getting blanks in calculated items

I am trying to implement the star schema P&L report from that article 

https://p3adaptive.com/2018/01/star-schema-switch-drill-income-statement-design/

so my report would like similar to this

Yurik74_0-1659685179267.png

And I have no issues with Revenue and COGS, however the first calculated item - Gross profit - shows nothing and it's omitted from the report. The second one (EBITDA) is blank as well - measure Test in the screenshot below.

 

My test data is very simple - 3 types of P&L lines - revenue, cogs, dda, and I want to have Profit as Revenue less COGS and EBITDA as profit less dda.

Yurik74_3-1659685937226.png

 

The relationship b/w lookup table and data table is established 

Yurik74_2-1659685851339.png

but looks like the Test measure does not generate anything for Gross Profit and EBITDA.

Measures look like this for lines from the data

Yurik74_4-1659686130652.png

and the main one (Test) which goes into the table is this

Yurik74_5-1659686185160.png

the one with dummy testing has dummy numbers for index 3 and 5

Yurik74_6-1659686225273.png

What puzzles me is that the calculation is working in the Data View - I can see Gross Profit of 165 and EBITDA of 154

Yurik74_7-1659686507495.png

 

But why it's not shown in the Pivot - I have no idea.

Anybody can explain what am I doing wrong? I have read the post several times but still stuck. Feels like the solution is simple, but can't find it.

 

1 ACCEPTED SOLUTION
ssysanny
Frequent Visitor

4 REPLIES 4
ssysanny
Frequent Visitor

Indeed it is, thanks. Will need to study your solution. Do you know why the originial measure was not working?

v-xiaotang
Community Support
Community Support

Hi @Yurik74 

Thanks for reaching out to us.

>> What puzzles me is that the calculation is working in the Data View......But why it's not shown in the Pivot

Not quite sure why they are different in these two places. Could you share the sample file for us to check? Thanks.

 

 

Best Regards,

Community Support Team _Tang

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

Thanks heaps for your reply, thought this will sink to the bottom 🙂

 

I can't really see how to add file to the forum so I have added that to GitHub

https://github.com/yuriksuturik/DAX-files

 

Hope that works.

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