How to apply Countif based on measure value

[Roy_tap]

Hi,

I have currently 2 tables as follows
Table 1 (Multiple Side filter apply to get the measure value)

Year	Resource	Measure Value
2024	A	1
2024	B	2
2024	C	0
2024	D	0
2024	E	3
2024	F	2

Table 2 (Same Multiple Side will be apply to get the measure (Countif) value)

Value (Static Value from 0 - 10m Measure value in table 1 will only be 0 - 10)	Measure (Countif)
0	2
1	1
2	2
3	1

How can I get the measure (Countif) based on the Resource count. 

Thanks

[Irwan]

hello @Roy_tap 

please check if this accomodate your need.

since you are mentioned about measure, i assumed you want to do this in measure form.

1. create a new measure with following DAX

Measure Countif = 
var _Value = SELECTEDVALUE('Table 2'[Column1])
Return
COUNTX(
    FILTER(
        'Table 1',
        'Table 1'[Measure Value]=_Value
    ),
    'Table 1'[Measure Value]
)

Hope this will help.

Thank you.

[Roy_tap · Accepted solution]

The measure is not returning anything. i am actually having a complex measure that doesnt reside inside Table 1, so i need to use calculatetable to store the Resource and Measure within the same object before countx.  

    var _Value = SELECTEDVALUE('Table 2'[Column1])

    RETURN

        COUNTX(

            CALCULATETABLE(

            FILTER(VALUES('Table 1'[Resource]),

            [Measure Value]=_Value

            )),

        [Measure value]

        )

Anyway thanks for the proposed solution.