Forum Discussion

MSW's avatar
MSW
Helper I
4 years ago
Solved

Counting a Specific Value per ID In PowerBI Table

Hello Community,    Can someone help me out seems I cannot find the correct DAX command for making a calculated column. I have made the measure but I really need it in a column format.    The Pro...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, MSW 

     

    You can try the following methods.

    Count of 'True' Value =
CALCULATE (
    COUNT ( 'Table'[ID] ),
    FILTER ( 'Table', [Text Values] = "TRUE" && [ID] = EARLIER ( 'Table'[ID] ) )
)

    When the ID is 567, the Count of 'True' Value should also be displayed as 1 because there is already a True value.

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, MSW 

 

You can try the following methods.

Count of 'True' Value =
CALCULATE (
    COUNT ( 'Table'[ID] ),
    FILTER ( 'Table', [Text Values] = "TRUE" && [ID] = EARLIER ( 'Table'[ID] ) )
)

When the ID is 567, the Count of 'True' Value should also be displayed as 1 because there is already a True value.

 

Best Regards,

Community Support Team _Charlotte

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