Need Suggestion - To calculate no. of Records in each RANK Variance (CY vs PY)

[Rajamanikandan]

Rank caluclated based on Current year and Prior Year Measures , and using conditional formatting to show the variance using icons in Matrix visual.

Measures used:

Rank CY = RANKX(ALLSELECTED(<Fieldname>,[<MEASURE>],,DESC)

Rank PY = RANKX(ALLSELECTED(<Fieldname>,[<MEASURE PY>],,DESC)

VAR - [RANK CY] - [Rank PY]

Ranking (Top N) calculated dynamically, based on user parameter (Setting page built to maintain parameters)

Ex: Top 10/N

Ask: List number of items Increased, Decreased and Equal (no change)

Expected Result:

No.of increased items - 6

No.of decreased items - 3

No change items - 1

[AlexisOlson · Accepted solution]

I think you can just count the number of each based on their sign.

No. Increased = COUNTROWS ( FILTER ( ALLSELECTED(<Fieldname>), [VAR] > 0 ) )

No. Decreased = COUNTROWS ( FILTER ( ALLSELECTED(<Fieldname>), [VAR] < 0 ) )

No. No Change = COUNTROWS ( FILTER ( ALLSELECTED(<Fieldname>), [VAR] = 0 ) )

[Rajamanikandan]

It works great, thank you so much.