Count Each Row Value in a Filtered Rows (Only for Visible Rows)

[rufinosilverio]

Hi Everyone! I am new here and with Power BI.

I have a table as follow:

 

In my report I have I filter where I Select for Class01 or Class02 or both.

I need to count, how many times each [GROUP} row is visible (Only visible values) when I select Class Filter.

I tried this, with Class01 selected in filter: 

CountGroup = CALCULATE(COUNTA(PRODUCTS[GROUP]), FILTER(RELATEDTABLE(PRODUCTS), PRODUCTS[GROUP] = EARLIER(PRODUCTS[GROUP])))

but Dont work, as follow showing only a value 1:

And I tried without RELATED, but it gave me the TOTAL of each Group ocurrences in the original table (8 for three first rows), that is not what I want.

CountGroup = CALCULATE(COUNTA(PRODUCTS[GROUP]), FILTER(PRODUCTS, PRODUCTS[GROUP] = EARLIER(PRODUCTS[GROUP])))

I need this Collumn [CountGroup] result when Class01 is selected in filter:

3

3

3

1

4

4

4

4

2

2

Thanks in advance!

[v-chuncz-msft · Accepted solution]

@rufinosilverio,

You may use DAX below to add a measure.

CountGroup =
CALCULATE (
    COUNT ( PRODUCTS[GROUP] ),
    ALLSELECTED ( PRODUCTS[CLASS] ),
    ALL ( PRODUCTS[PRODUCT] )
)

[rufinosilverio]

@v-chuncz-msft,

Thank you so much!

It worked for me!!!

Regards!!!