Forum Discussion
Solved
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 ...
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.
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.