Ignore Selections on a Chart - Pivot Table - "No Measures"

ltc — Mon, 20 Dec 2021 21:05:46 GMT

Hi everyone,

I need a pivot table to ignore selections of the following fields: [Rating] [Date] [Progress] and [Is Current].

I know to normally add {1} to set analysis in the measure, but this pivot table doesn't use a typical measure with a sum/count/avg/etc. function, so I don't know how to incorporate set analysis into it and use {1}.

These are my dimensions/measures:

Row Dimension: Category
Column Dimension: Date
Measure:
= If(IsNull([Rating]),'Not Rated',[Rating])
& ' ' &
Pick(WildMatch([Progress], 'Steady Performance', 'Negative Performance', 'Positive Performance') + 1, '', chr($(ASCII.RightTriangle)), chr($(ASCII.DownTriangle)), chr($(ASCII.UpTriangle)))

Note: I have my chart calculation condition set to GetPossibleCount([Program]) = 1

I'm attaching a sample data set and screenshot of what the pivot table looks like. The pivot works as is, but again, I don't want it to respond to selections of the fields mentioned above. I would also be okay with an expression that keeps the pivot table from responding to selections of any field.

Please help! Thanks!

Re: Ignore Selections on a Chart - Pivot Table - "No Measures"

Anil_Babu_Samineni — Mon, 01 Feb 2021 07:16:10 GMT

You can try this way?

= If(IsNull([Rating]),'Not Rated',[Rating])
& ' ' &
Pick(WildMatch(Only({<[Rating]=, [Date]=, [Progress]=, [Is Current]>} [Progress]), 'Steady Performance', 'Negative Performance', 'Positive Performance') + 1, '', chr($(ASCII.RightTriangle)), chr($(ASCII.DownTriangle)), chr($(ASCII.UpTriangle)))

Re: Ignore Selections on a Chart - Pivot Table - "No Measures"

ltc — Mon, 01 Feb 2021 13:00:53 GMT

That didn't work.

topic Re: Ignore Selections on a Chart - Pivot Table - "No Measures" in App Development

Ignore Selections on a Chart - Pivot Table - "No Measures"

Re: Ignore Selections on a Chart - Pivot Table - "No Measures"

Re: Ignore Selections on a Chart - Pivot Table - "No Measures"