Remove unwanted lines of data?

[Creative_tree88]

Hi all - I have a dataset where there can be multiple lines of data, per event (see link below - sample data) but I only want to have the lines of datsa which have an actual dosage in it, rather than just zero.  So, in the sample data, you'll see the same event key, but there is often a 'rogue' line of data which has same event key but a zero.  This zero IS in the data, but for analysis purposes I want to exclude it as a line of data - only showing the event key line with something in it.

Many thanks all.

Sample Data 

[danextian · Accepted solution]

Hi @Creative_tree88 

You can filter it out within the measure:

CALCULATE (
    SUM ( 'table'[dosage] ),
    FILTER ( VALUES ( 'table'[dosage] ), 'table'[dosage] <> 0 )
)

You can use the query editor to filter it out

Or exclude using the filter pane