topic Re: How to apply Countif based on measure value in DAX Commands and Tips

How to apply Countif based on measure value

Roy_tap — Thu, 20 Feb 2025 02:22:18 GMT

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

Re: How to apply Countif based on measure value

Irwan — Thu, 20 Feb 2025 02:53:14 GMT

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.

Re: How to apply Countif based on measure value

Roy_tap — Thu, 20 Feb 2025 05:54:31 GMT

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.