Countrows and summarize

[SarahLamblin]

Good morning,

I've created a matrix table using 4 columns and one measure.

It is a matrix table to visualize article numbers based on Article Status, Article type and Article group.

The aim is to retrieve the number of articles per Article group.

This the measure I initially created:

Aantal artikels =
VAR aantalartikels =
COUNTROWS(
SUMMARIZE(Artikelgegevens, Artikelgegevens[Artikelstatus], Artikelgegevens[Artikelsoort],
ArtikelGroepOmschrijving[ArtikelgroepOmschrijving], Artikelomschrijving[ArtikelNr])
)

RETURN
aantalartikels

But that gives the following result: (The totals per Article Group are correct, but I want to leave the count of Article Nr per row. I don't want to see the number 1 on each row next to article number.)

So the I tried the following measure:

Aantal artikels =
VAR aantalartikels =
COUNTROWS(
SUMMARIZE(Artikelgegevens, Artikelgegevens[Artikelstatus], Artikelgegevens[Artikelsoort],
ArtikelGroepOmschrijving[ArtikelgroepOmschrijving], Artikelomschrijving[ArtikelNr])
)

RETURN
IF(ISFILTERED(Artikelomschrijving[ArtikelNr]), blank(), aantalartikels)

But when I use this measure the Article Numbers on itself are no longer visible.

I do want to see the Article Numbers, but not the value of 1 next to each article number.

Can someone help me to obtain this result?

Thank you!

[v-rongtiep-msft · Accepted solution]

Hi @SarahLamblin ,

I have created a simple sample. Please have a try.

VAR aantalartikels =
COUNTROWS(
SUMMARIZE('Table','Table'[ArtikelSoort],'Table'[ArtikelStatus],'Table'[ArtikelgroepOmschriving],'Table'[Gemarieerd]))

RETURN
MAX('Table'[Gemarieerd])

If it is possible, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SarahLamblin]

I've also tried using if(isinscope instead of if(isfiltered, but the result is still not what I want