topic PowerBi Desktop in DAX Commands and Tips

PowerBi Desktop

Himaja95 — Wed, 12 Jun 2024 17:23:05 GMT

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'))

Re: PowerBi Desktop

rajendraongole1 — Wed, 12 Jun 2024 17:38:03 GMT

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

Re: PowerBi Desktop

rajendraongole1 — Wed, 12 Jun 2024 17:45:44 GMT

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