Forum Discussion
Helper IHow to apply Countif based on measure value
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
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])RETURNCOUNTX(CALCULATETABLE(FILTER(VALUES('Table 1'[Resource]),[Measure Value]=_Value)),[Measure value])
Anyway thanks for the proposed solution.
2 Replies
IrwanSuper User
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_tapThe 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])RETURNCOUNTX(CALCULATETABLE(FILTER(VALUES('Table 1'[Resource]),[Measure Value]=_Value)),[Measure value])
Anyway thanks for the proposed solution.