Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
The relationship b/w lookup table and data table is established
but looks like the Test measure does not generate anything for Gross Profit and EBITDA.
Measures look like this for lines from the data
and the main one (Test) which goes into the table is this
the one with dummy testing has dummy numbers for index 3 and 5
What puzzles me is that the calculation is working in the Data View - I can see Gross Profit of 165 and EBITDA of 154
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.
Solved! Go to Solution.
see it is what you need.
Indeed it is, thanks. Will need to study your solution. Do you know why the originial measure was not working?
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.
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |