Forum Discussion
Anonymous
5 years agoNot applicable
Create EBITDA scheme with DAX (Matrix visual)
Hey everyone! I want to recreate the scheme to calcute the EBITDA or EBIT. You have subcategories like revenue, interest & depreciation and also main categories like EBIT & gross p...
Anonymous
5 years agoNot applicable
amitchandak @ amitchandak
I made this in Excel and transfered it to PowerBi. The values without a specifiek measures are 'Direct Sales Stores' and the some rows are with specific measures like 'EBITDA'.
I tried, after reading the articles, the next: (Amount_rapportering is were the values are, Grootboek[sub] is the table from Excel.
Poging 1 =
CALCULATE([Amount_Rapportering], Grootboek[Sub] = "Inkomst")Poging 2 =
CALCULATE([Amount_Rapportering], Grootboek[Sub] = "Extra Inkomst")
calculate the Gross Margin
Gross Margin =
var Inkomst = CALCULATE([Amount_Rapportering], Grootboek[Sub] = "Inkomst")
var Extra = CALCULATE([Amount_Rapportering], Grootboek[Sub] = "Extra inkomst")
return
Inkomst + Extra
Komop =
var Currentitem = SELECTEDVALUE(Blad2[Naam])
return
SWITCH( TRUE(),
Currentitem = "Gross Margin",DIVIDE([Gross Margin], 1, 0),
calculate ([Amount_Rapportering],
FILTER(Blad2, Blad2[Naam] = Currentitem)))
What happend after I use the new measure 'Gross Margin' in the matrix. It didn't work. Any idea why?
v-easonf-msft
5 years agoCommunity Support
Hi, Anonymous
I'm a little confused by your description. Can you explain bit more?
A simplified pbix file can better help us understand the problem.
Best Regards,
Community Support Team _ Eason