Forum Discussion
Solved
Problem dividing one column by another
I'm very new to Power BI, so please go easy on me here. I am trying to calculate scanning percentage based on branch. So my data would look something like this: Branch Electronic Signature ABC ...
Hi epmck11,
According to your description, you want to calculate the percent of signed records of current type, right?
Percent of current Branch =
CALCULATE (
COUNTA ( 'Table'[Electronic Signature] ),
'Table'[Electronic Signature] = "Y",
VALUES ( 'Table'[Name] ),
ALLSELECTED ( 'Table' )
)
/ CALCULATE ( COUNTROWS ( ALLSELECTED ( 'Table' ) ), VALUES ( 'Table'[Name] ) )
Percent of all Branch=
CALCULATE (
COUNTA ( 'Table'[Electronic Signature] ),
'Table'[Electronic Signature] = "Y",
VALUES ( 'Table'[Name] ),
ALLSELECTED ( 'Table' )
)
/ COUNTROWS ( ALLSELECTED ( 'Table' ) )Regards,
Xiaoxin Sheng
