PowerBi Desktop

[Himaja95]

Hi
I am trying to create a measure for the table visual to be empty until a filter is selected.

Filters:(coming from different tables)

'Program,Project,Month,FiscalYear ,VP, Project Manager ,Senior Executive

Table visual should display from Project data table:

Project,PM,Startdata,Golivedate

Measure :
IsAnyFilterApplied =
CALCULATE(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)  
    ALLSELECTED('Project Data'))

[rajendraongole1 · Accepted solution]

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!!

[rajendraongole1]

Hi @Himaja95 - if it works, please mark my post as a solution. 

Thank you

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