Number of row adjusted to filters

[joannasokolowsk]

Hey,

I would like to ask you for an advise regarding adding new column to the tabel chart which will show number of row. Also, this needs to change according to filters/slicers. 

Example  - this is the table where I would like to see No of row for each line (sample of the date - in original one there are more rows and columns) 

No	Name	Course	Country	language
1	John	AC	US	EN
2	John	PC	US	EN
3	Anna	BK	US	PL
4	Anna	AC	US	PL
5	Kate	PC	Italy	PL
6	Kate	ZD	Italy	PL

When I filter only Italy under Country , No should change accordingly (I can also select multiple filters at once - language, country, course etc) Kate was 5-6 but now should be 1-2. 

No	Name	Course	Country	language
1	Kate	PC	Italy	PL
2	Kate	ZD	Italy	PL

Thank you in advance!

Asia

[harshnathani · Accepted solution]

HI @joannasokolowsk ,

Create a measure

Ranki = RANKX(ALLSELECTED(Table7),CALCULATE(SUM(Table7[No])),,ASC)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

HI @joannasokolowsk ,

Create a measure

Ranki = RANKX(ALLSELECTED(Table7),CALCULATE(SUM(Table7[No])),,ASC)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[joannasokolowsk]

Hey,

I tried to use it but the thing is that I do not have No column in my dataset 🙂 I want to create it to show the row number 🙂 Can you please hep with changing this expression ?

Thanks,

Asia

[harshnathani · Accepted solution]

HI @joannasokolowsk ,

Simply create an index column in Power Query.

Regards,

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[joannasokolowsk]

Perfect thanks!

[harshnathani]

HI @joannasokolowsk ,

You can also try this DAX

Rankii = RANKX(ALLSELECTED(Table7),CALCULATE(CONCATENATE(MAX(Table7[Course]),MAX(Table7[language]))),,ASC)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

You need to use the Rankx function of DAX. click here to see a detailed example