Forum Discussion

BrianaHop's avatar
BrianaHop
Helper I
5 years ago
Solved

Filtering a Measure with Another Measure

I am still pretty new to Power BI and am having an issue with a date filter. I am creating a Payroll report that has 2 tables. One table is week to week Payroll Data (Overtime, Hours Worked, etc.). T...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hello, @BrianaHop

    It's a pleasure to answer for you.

    According to your description, I think you can create a measure, then use it in the filter pane.

    Like this:

    measure =
IF (
    CALCULATE (
        COUNT ( 'HiredEmployees'[Hire_Date] ),
        DATEADD ( 'Date'[Date], -15, DAY )
    )
        = BLANK (),
    0,
    1
)

    1.png

    If you do not solve your problem, please feel free to ask me.

    Best regards

    Janey Guo

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hello, @BrianaHop

It's a pleasure to answer for you.

According to your description, I think you can create a measure, then use it in the filter pane.

Like this:

measure =
IF (
    CALCULATE (
        COUNT ( 'HiredEmployees'[Hire_Date] ),
        DATEADD ( 'Date'[Date], -15, DAY )
    )
        = BLANK (),
    0,
    1
)

1.png

If you do not solve your problem, please feel free to ask me.

Best regards

Janey Guo

If this post helps,then consider Accepting it as the solution to help other members find it faster.