Measure for Table Visual to Display Column Values

[StuartSmith]

I have a table visual currently with 3 columns.

Region = Data Table Column

Within 35 Days = Measure that divides the number of rows with a specific value by the total number of rows.

KPI Status = Measure that displays "Expected KPI Met" or "KPI Breached" depending on  value of "Winth 35 Days" Measure.

But I want the "Region" column not to display the Region names if there are no rows.

So instead of having the "Region" column using the "Region" column called 

"Table: MSIP Time to Fill SLA'[Region]" for the Data Table, I have been trying to create a measure something like...

Test =

VAR CountTimeToFillRows = COUNTROWS('Table: MSIP Time to Fill SLA')

Return

IF(CountTimeToFillRows = 0, " ", {Display Region Names})

But I can get it to work.  Is this possible and if so, how?

Thanks in advance.

[Nilupul · Accepted solution]

Try like this:
Create a measure as below to check values are available to the measure

Is Data Available = IF(ISBLANK([KPI Status]) && ISBLANK([Within 35 Days]) , 0,1)

Then put this measure as a visual level filter . After that filter with is 1.  

If is blank not work try with [KPI Status] = ""

[StuartSmith]

Thanks, I had to change the measure a bit, but your solution gave me a base code to get it working. 👍