@Anonymous
I don't think you explained the calculation well enough for anyone to understand and help you with this. This post is from Tuesday. Today is Thursday, and still no replies. That means people just don't understand the logic. Please be more precise next time. I wanted to understand the logic but this seems to not make much sense:
"This is because we are involved in 3 Accounts out of a total of 6 Accounts that are in scope once the unnessecary filters are removed as part of the measure."
As much as I can see from the table, there are only 2 accounts (as differentiated by Account STID), Account STID of 1 and 4, which have at least one entry of "Involved" and there are 6 accounts in total, indeed, after filtering. In fact, I think what you really mean is not "3 Accounts" but 3 entries in the table that have Active Involvement of "Involved." This is somethnig different than what you are describing. It's not about accounts, it's about the rows in the table where only the entries in the last column are most important for the calculation.
Based on the above, the measure would be:
// Let T be your table.
// This is a bad design since you should have
// a fact table and dimensions but...
// you'll bear the consequences of this
// so I'm not gonna dwell upon it any longer.
[Ratio] =
var Result =
CALCULATE(
DIVIDE(
CALCULATE(
COUNTROWS( T ),
KEEPFILTERS( T[Activity Involvement] = "involved" )
),
COUNTROWS( T )
),
KEEPFILTERS( T[Account STID] <> "No STID" ),
KEEPFILTERS( T[Opportunity ID] <> "No Opp Created on Account" )
)
return
// Return (Result * 1) if you want
// to see those rows which will return
// BLANK (meaning the ratio is 0%). The
// multiplication of Result by 1 will
// coerce BLANK into 0. And by the way...
// never return a string like '12.2%' from
// a measure that should return a number.
// For this you should use formatting from
// the ribbon. Just saying...
Result
