Show a specific column data When no filter is selected

Hi Alde , 

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure.

Measure = IF(ISFILTERED('Table'[month])=TRUE(),FIRSTNONBLANK('Table'[value%],1),CALCULATE(SUM('Table'[value%]),'Table'[month]=SELECTEDVALUE('Table (2)'[date])))

What cause your error?

The following comparisons are not supported:

1. 1. Comparing to a column to a measure. SalesHeader[TerritoryID] = [LargestTerritory]
   2. Comparing a column to a an aggregate value. SalesHeader[TerritoryID] = MAX(TerritoryID[TerritoryID]])
   3. Comparing a column to a What-If parameter. SalesHeader[TerritoryID] =TerritoryParameter[TerritoryParameter Value]

More details: DAX error: A function ‘XXXX’ has been used in a True/False expression that is used as a table filter expression. This is not allowed. 

If I have misunderstood your meaning, please provide your pbi file without privacy information and your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.