count number of rows with value in it for given slicer value

[Anonymous]

New to dynamic calaculations, need help.

Table A (Dimension, Slicer) 

Product Id Product Name

123             abc

234             def

Table B (Fact, Table Visual)

Product Id        Sold date      Location Sold

123                   12th sept       NY

123                   15th Sept     

234                   11th Sept      NY

234                   15th Spet      ATL

Report - 

1.  Has a slicer to pick product id

2. A table, or card visual to show a "Location Data Missing" flag as "Yes" if there any null/blank values for the "Location Sold" field. 

For the above table data example - when the slicer is filtered for Product Id 123 -  The "Location Data Missing" will be "Yes"and for Product Id 234 it will "No"

Need help creating a calaculated column or measure, not sure how to get started. 

[isjoycewang · Accepted solution]

Hi @Anonymous ,

Try to create below measure in the card visual:

Location Data Missing = 
IF( COUNTBLANK('Fact'[Location Sold]) > 0 , "Yes", "No" )

Best Regards,

Joyce

[Anonymous]

thank you @isjoycewang !