Filter a measure by another one

[seekrohit1]

Below is the scenario:

1. Need to calculate the Total number of jobs from Jobs table which is connected to the Fact Table (one-to-many)

2. From the Fact table there is already a %measure <measure1> which is already caculated by using DAX.

3. Need to calculate the Total Number of Jobs where the %measure is less than 5%

[aditya0125]

No of Jobs = Countx( filter(Value([JOB ID]), [Measure%] < .05 ), [JOB ID])
i think this will works.

[Anonymous]

Hi  @seekrohit1 ,

Here are the steps you can follow：

1. Create measure.

Measure 2 =
CALCULATE(
    DISTINCTCOUNT('Jobs Table'[JobID]),
   FILTER(ALL('Fact Table'),
    [Measure 1]<0.05))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@seekrohit1 ,

Countx( filter(Values(Jobs[JOB ID]), [%Measure] <.05 ), [JOB ID])