Forum Discussion
Countrows and summarize
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!
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.
2 Replies
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.
I've also tried using if(isinscope instead of if(isfiltered, but the result is still not what I want
