PowerBi Desktop

Hi Himaja95 - Create a measure that checks if any of the specified filters are applied. This measure should return 1 if any filter is applied and 0 otherwise

Measure FYR:

IsAnyFilterApplied =
IF (
ISFILTERED('Portfolio'[Program]) ||
ISFILTERED('Project Data'[Title CapMetro ID]) ||
ISFILTERED('Finance Data'[Date].[Month]) ||
ISFILTERED('Finance Data'[FiscalYear_colum]) ||
ISFILTERED('Project Data'[VP]) ||
ISFILTERED('Project Data'[Project Manager]) ||
ISFILTERED('Project Data'[Senior Executive]),
1,
0
)

create another measure that conditionally displays data from the Project Data table only if IsAnyFilterApplied equals 1. If IsAnyFilterApplied equals 0, the measure should return BLANK().

DisplayProjectData =
IF (
[IsAnyFilterApplied] = 1,
1,
BLANK()
)

Apply a visual-level filter with DisplayProjectData equals 1.

it works, as If no filters are applied, the measure will return BLANK(), and the table visual will be empty.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!