Need help in filtering using measure in power bi

Question

I have 2 measures in my power bi report which show cumulative trend based on two date columns namely created date and closed date. The 2 trend lines show total number of bugs created vs total number of closed bugs at specific dates.

Total Created Bugs:

Measure1 = CALCULATE(COUNTROWS(Sheet1),FILTER(ALLSELECTED(Sheet1),Sheet1[CreatedDate]<=MAX(Sheet1[CreatedDate])))

Total Closed Bugs:

Measure2 = var totalEpics= CALCULATE( COUNTROWS(Sheet1), FILTER ( ALL(Sheet1), IF(Sheet1[ClosedDate] <> BLANK() ,Sheet1[ClosedDate] <= MAX(Sheet1[CreatedDate]),0))) var val = IF(ISBLANK(totalEpics),0,totalEpics) RETURN val

Issue is that If I change the date in slicer then measure1 is recalculated correctly but measure 2 is not recalculating according to slicer

davidebacci · Accepted Answer · 2024-07-25 18:17:27Z

2

What happens if you replace ALL with ALLSELECTED

   Measure2 = 
VAR totalEpics = 
    CALCULATE(
        COUNTROWS(Sheet1), 
        FILTER(
            ALLSELECTED(Sheet1), 
            IF(Sheet1[ClosedDate] <> BLANK(), Sheet1[ClosedDate] <= MAX(Sheet1[CreatedDate]), 0)
        )
    )
VAR val = IF(ISBLANK(totalEpics), 0, totalEpics) 
RETURN val

edited Jul 25, 2024 at 18:17

user9517769

answered Jul 25, 2024 at 8:41

davidebacci

31.4k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need help in filtering using measure in power bi

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related