Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
defrugo
Frequent Visitor

Filtering Problem

I have following scenario: (not specifying all the columns)

Table: DimProject
Columns: ProjectName, Project Description, Year

 

Table: FactExpanseRequest

Columns: ProjectName, PONumber, StartDate, EndDate

 

DimCalendar

Columns: YYYYMM, Year, DateField

 

Relations:

M:M DimCalendar[Year]:DimProject[Year]

1:M DimProject[ProjectName]:FactExpanseRequest[ProjectName]

 

I've created measure to mark if during specific month PO is executed or not:

 

BetweenDates =
VAR EarliestDate = MIN(FactExpenseRequest[StartDate])
VAR LatestDate = MAX(FactExpenseRequest[EndDate])
  RETURN

  IF (
        AND (
            MAX(DimCalendar[DateField]) >= EarliestDate,
            MIN(DimCalendar[DateField]) <= LatestDate
        ),
        1,
        0
    )

 

Measure works fine, but when i put it into matrix with: PONumber on Rows and YYYYMM on columns I lose filtering option, by highlighting related attributes from DimProject table in other Visual:

 

Matrix with PO vs YYYYMM:

defrugo_0-1690540450942.png

 

which is filtered by clicking on specific project in this table:

 

defrugo_1-1690540500567.png

So when i Click on project, there is no reaction in table with POs.

 

But, when i change measure to display BLANK() instead of 0s, filtering works just fine. What could be the reason of such behavior?

 

 

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.