SUMMARIZE with a WHERE Clause

[DebbieE]

SummaryTable =

SUMMARIZE (

'fact Fact',

'fact Fact'[ID],

"Frequency", COUNT ('fact Fact'[ID]))

Ive created a table as above to get frequencies of an ID

However I have alot of Null IDs in the table (Set to 0) and I dont want them adding to the table because there are too many records against them. For example

ID    Frequency

0     1023

93   4

23   2

11   1

29   3

66   3

Is there any way I can clear out anything where ID = 0 in this Summary table?

[Anonymous]

If it's visual only you can simply use the build in filter panel. 

Drag the frequency field into the filters pane and filter out "is not 0"

[DebbieE]

I use it for another DAX query so I want it built into the statement

[DebbieE · Accepted solution]

SummaryTable =

SUMMARIZE (

'fact Fact',

'fact Fact'[ID],

"Frequency", IF('fact Fact'[ID]<>"0",COUNT ('fact FactComplaints'[ID]))

)

Sorted. if the ID is not 0 then continue with the count. Else do nothing