Forum Discussion
Need help filtering with a dax expression
Hi!
Can somebody assist me with this calculation as I have minor trouble:
I have a column which I want to count, but I want to exclude all the rows in that column containing the number "110". How would I write a DAX expression for this?
So I want to have something like: "Count all the values in this column, except those cells containing "110".
Hoping somebody can help,
Thanks
Hi, Anonymous
Please check the below picture and the sample pbix file's link down below.
Count except 110 =
COUNTROWS ( FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[ColumnA], "110" ) ) )https://www.dropbox.com/s/2ppp72bfmuegzd3/pbiuser.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
3 Replies
- Jihwan_Kim
Super User
Hi, Anonymous
Please check the below picture and the sample pbix file's link down below.
Count except 110 =
COUNTROWS ( FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[ColumnA], "110" ) ) )https://www.dropbox.com/s/2ppp72bfmuegzd3/pbiuser.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
PaulDBrownCommunity Champion
Try:
rows =
VAR calc = SUM(Table[column])
RETURN
CALCULATE ( COUNT(Table [column]), FILTER (Table [ column ], calc <> 110)