Forum Discussion
How to count rows with additional logic (countrows/countx)
- 8 years ago
Hey,
maybe this measure provides what you are looking for.
Countrows Summarize = COUNTROWS( SUMMARIZE('Table1' ,Table1[Task] ,Table1[Config.] ) )It results to 6.
Using SUMMARIZE allows to create a table using just the columns you want.
You can also use
ADDCOLUMNS(
SUMMARIZE(...),"NewColumnName 1", Expression
,...
)For more examples using SUMMARIZE and ADDCOLUMNS please have a look here:
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Hopefully this is what you are looking for
Regards
Tom
Hey,
maybe this measure provides what you are looking for.
Countrows Summarize =
COUNTROWS(
SUMMARIZE('Table1'
,Table1[Task]
,Table1[Config.]
)
) It results to 6.
Using SUMMARIZE allows to create a table using just the columns you want.
You can also use
ADDCOLUMNS(
SUMMARIZE(...)
,"NewColumnName 1", Expression
,...
)
For more examples using SUMMARIZE and ADDCOLUMNS please have a look here:
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Hopefully this is what you are looking for
Regards
Tom