Financial Ratio Percentage of Revenue

[johnghannam]

Hi guys,

I'm trying to apply financial ratio measure that takes a general ledger account divided by Total Revenue number

The measure that you see below it shows Total Revenue by company, company being  PnLSynopsisAllData[BusinessUnit] = 17000

However I want the company to be dynamic not static, I'm currently entering company number in my filter.

EVALUATE
ADDCOLUMNS(PnLSynopsisAllData
		   ,"Actual Total Revenue Per Company",SUMX(Filter(PnLSynopsisAllData,PnLSynopsisAllData[RowIndex]=22 && PnLSynopsisAllData[BusinessUnit] = 17000),PnLSynopsisAllData[Actual])		   									   
		   							          
		   )
Order By PnLSynopsisAllData[BusinessUnit],PnLSynopsisAllData[RowIndex]

Could you please assist?

Thank you

John

[v-shex-msft]

Hi @johnghannam,

You can try to use measure to get selected value from slicer, then use these value to calculate.

For example:

Seleceted Value= If(HasOneValue(Table[Column]),Values(Table[Column]),Blank)

>>However I want the company to be dynamic not static, I'm currently entering company number in my filter.

Currently, power bi only support dynamic measure based on slicer, you can't  create a dynamic table/calculate column based on slicer or filter.

Regards,

Xiaoxin Sheng

[MFelix]

Hi @johnghannam,

If the number of.your company is a number and you have it in slicer you can change the number by the formula.


MIN( PnLSynopsisAllData[BusinessUnit] )

When you choose the company number in the slicer that will return what you need however if you select more than one this will give the first company of the ones.you choose.

If you put this on one table since the measure takes into account the context it will give you the calue for each row selected.

Do you need more than one?

Regards
MFelix