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 Problem: Want to count the total times a value appears in a column per ID. 

 

Table looks like:

 

IDText ValuesCount of 'True' Value
123

False

1
345True2
567Blank0
123True1
345True2
567True1
789False0

 

 

Thank you!

  • 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.

4 Replies

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    Hi:

    When naming your table "Data" we can try this calculated column:

    True Times =
    var id_value = Data[ID]
    return
    IF(Data[Text Values] = "TRUE",
    COUNTROWS(
    FILTER(ALL(
    Data),
    Data[Text Values] = "TRUE" &&
    Data[ID] = id_value)))
     

    I hope this helped!

  • MSW's avatar
    MSW
    Helper I
    4 years ago

    Whitewater100 This worked fantastic thank you. I was trying to put the IF statement after countrows. This helped solve my problem and help me learn better options. Thank you! 

    • Whitewater100's avatar
      Whitewater100
      Solution Sage
      4 years ago

      Hello- No problem and I understand. Are you able to mark it as a solution? Thanks!

  • 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.