topic Counting a Specific Value per ID In PowerBI Table in DAX Commands and Tips

Counting a Specific Value per ID In PowerBI Table

MSW — Thu, 31 Mar 2022 22:56:27 GMT

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:

ID	Text Values	Count of 'True' Value
123	False	1
345	True	2
567	Blank	0
123	True	1
345	True	2
567	True	1
789	False	0

Thank you!

Re: Counting a Specific Value per ID In PowerBI Table

Whitewater100 — Fri, 01 Apr 2022 00:47:22 GMT

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!

Re: Counting a Specific Value per ID In PowerBI Table

MSW — Fri, 01 Apr 2022 02:12:27 GMT

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!

Re: Counting a Specific Value per ID In PowerBI Table

Whitewater100 — Fri, 01 Apr 2022 11:03:58 GMT

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

Re: Counting a Specific Value per ID In PowerBI Table

v-zhangti — Tue, 05 Apr 2022 03:00:12 GMT

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.