Remove rows with missing numbers

[Hardik]

Hello everyone 
! i want to remove the rows which has blank bh or pc for a particular date.Kindly help me with the same.I just want the rows that have both bh and pc 

[v-chuncz-msft · Accepted solution]

@Hardik,

Drag measure below to visual level filter and set Show items when the value is 2.

Measure =
DISTINCTCOUNT ( Table1[CategoryBHorPC] )

[danextian]

Hi @Hardik,

Please try this measure:

With BH and PC Only =
VAR VALUE_ =
    COUNT ( 'Table'[Visits] ) /*here you can replace COUNT() with
	 the correct aggregation, SUM(), AVERAGE(), COUNTA(), etc */
VAR BH =
    CALCULATE ( VALUE_, 'Table'[BHorPC] = "BH" )
VAR PC =
    CALCULATE ( VALUE_, 'Table'[BHorPC] = "PC" )
RETURN
    IF ( ISBLANK ( BH ) || ISBLANK ( PC ), BLANK (), VALUE_ )
/*if either BH or PC is blank, 
return blank otherwise the value, 
items with blank value are hidden in Power BI visuals */