Total Function behavior

[RutiTaumanRubin]

Hi,

I have created measure  that in the denominator ignore Year Dim:

count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count({<Year=,TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)

When I defined KPI with this measure I received the number 103% as a result.

When I defined as a graph\table with this measure and Year field as a dim I received the number 106% as a result and the number 103% as total function Auto (You can see printscreen in the attachment)

Do you know why its occur?

Thanks!

[tresesco · Accepted solution]

You used Year in set analysis causing that disregards the year field selection. For disregarding dimension in a chart for totaling, try like:

count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count(Total <Year> {<TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)