P&L - Cost to Net Sales Percentage

[Aravind_Kumar]

Hello; There are couple of post similar to this topic, but i am still having issues.

Below is the Matrix. This is coming from one fact table, where Gl are grouped into Revenue & Exp and one column for Total Value.

So how to get the Percentage of Net sales for the expense items ?

		% of Net Sales
Revenue	1000
Material Cost	-400	-40%
Direct Cost	-150	-15%
Indirect Cost	-100	-10%
Others	-50	-5%
Gross Profit	300	30%

[Aravind_Kumar]

working on live data... so...

Its a single fact table which has all the GL and with Values.. which has relationship to one GL Mapping table to arrive the expense group and another calendar table for time period...

Fact table like this

GL | GL $ | Period |

All GL (Revenue & Costs) are in single fact table..

[Aravind_Kumar · Accepted solution]

THANKS..

I USED ALLSELECTED FUNCTION BASED IN SOLUTION FROM ANOTHER POST WHICH FIXED THE ISSUE

[Ashish_Mathur]

Hi,

To your Table visual, drag the GL category to the row labels.  Write these measures

Total = sum('Fact Table'[GL $])

Rev = calculate([Total],'GL Categories'[Category]="Revenue")

% of net sales = divide([Total],[Rev])

Hope this helps. 

[Ashish_Mathur]

Hi,

The solution would depend upon the structure of Tables in the backend.  Share the download link of your PBI file.