Click Donut KPI is Impacting

[selvakumara]

Hi

I have Donut And KPI .

Donut - The donut have sub categories

KPI - It will display the total based on selection.

But, if i select any sub- categories in the Donut KPI also changing. Even I i have ignore all selections

My Expression :

Donut :

Measure : Count({$<[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Dimension : it will display sub categ of "xcvxcvxcv' "

KPI :

Count({1<[Month]={$(TestMultipleMonths)},[Group]=P([Group]),[Name] =P([Name]),[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Any Idea?

Thanks in advance.

[sunny_talwar]

You don't want selections to impact donut? May be this

Count({1<[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

[selvakumara]

I want donut selection don't impact on KPI.

KPI  :

Count({1<[Month]={$(TestMultipleMonths)},[Group]=P([Group]),[Name] =P([Name]),[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

[sunny_talwar]

May be try this

Count({1<[Month]={$(TestMultipleMonths)}, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Also, how do you define TestMultipleMonths? Is it an expression? If it is, then you might have to ignore all your selections within that variable's definition also

[selvakumara]

if i selected multiple months          [Month] = 2017-07,2017-08..............2017-11  means

TestMultipleMonths Calculation

=Concat( DISTINCT chr(39)&(Left([Month],4)-1)&'-'&Right([Month],2)&chr(39) , ',')

TestMultipleMonths -  It will give values like '2016-07,2016-08..............2016-11'

Then I have used

Count({1<[Month]={$(TestMultipleMonths)}, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records).

Still KPI is changing, How can i apply

Thanks in advance.

[sunny_talwar]

How about you try this

Count({1<[Month]=$::Month, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)