DAX measure for selecting rows based a filter

[Anonymous]

Hello guys, can you please help with a DAX measure to return rows where a value is 0.  I would like to create something like this below.

To those of you guys familiar with SQL, the synthax would be similar to

(select * from sciences where attendances = 0)

union all 

(select * from arts where attendances = 0)

Thanks in advance

[Ashish_Mathur · Accepted solution]

Hi,

Append data from both tables.  Then build a visual by dragging the Subject column from the appended table and write this measure

=SUM(Data[Attendances])

Now filer on this measure with a criteria > 0.

Hope this helps.

[Zubair_Muhammad]

@Anonymous

You can create a Calculated Table in Power BI

From the Modelling Tab>>>NEW TABLE

Table =
FILTER ( UNION ( Sciences, Arts ), [Attendances] = 0 )

[Anonymous]

thanks for your help, What's the DAX syntax for the measure [Attendances]?

[Ashish_Mathur]

Hi,

I am not sure of whom you are replying to but have you tried the SUM() function which i suggested in my previous post.

[Anonymous]

Thanks Ashish, I tried your method and it worked.. thanks alot. 

[Ashish_Mathur]

You are welcome.