How to get count of specific column in the table

[bzeeblitz]

I have column po# where I need to check count of this column such that how many times it has been occurred 

[DataNinja777 · Accepted solution]

Hi @bzeeblitz ,

To calculate how many times each value in the po# column has occurred, you can use either a measure or a calculated column in Power BI, depending on your requirements.

If you need the count to update dynamically based on filters in your report, you can create a measure. The measure can be written as follows:

Po# Count = COUNTROWS(FILTER('poitem', 'poitem'[po#] = SELECTEDVALUE('poitem'[po#])))

This measure counts the number of rows where the po# value matches the selected value in the report, making it responsive to slicers and filters.

Alternatively, if you need a static count that calculates the number of occurrences for each po# in the table without being influenced by filters, you can create a calculated column. The formula for this column is:

Po# Count = 
CALCULATE(
    COUNT('poitem'[po#]),
    ALLEXCEPT('poitem', 'poitem'[po#])
)

This calculated column computes the total count of each po# while grouping by the po# column and ignoring other filters in the table. Depending on whether you need a dynamic or static result, you can choose the appropriate approach.

Best regards,

[Kedar_Pande · Accepted solution]

@bzeeblitz 

Measure:

PO Count Measure = COUNTX(FILTER('Table', 'Table'[po#] = MAX('Table'[po#])), 'Table'[po#])

[DataNinja777 · Accepted solution]

Hi @bzeeblitz ,

To calculate how many times each value in the po# column has occurred, you can use either a measure or a calculated column in Power BI, depending on your requirements.

If you need the count to update dynamically based on filters in your report, you can create a measure. The measure can be written as follows:

Po# Count = COUNTROWS(FILTER('poitem', 'poitem'[po#] = SELECTEDVALUE('poitem'[po#])))

This measure counts the number of rows where the po# value matches the selected value in the report, making it responsive to slicers and filters.

Alternatively, if you need a static count that calculates the number of occurrences for each po# in the table without being influenced by filters, you can create a calculated column. The formula for this column is:

Po# Count = 
CALCULATE(
    COUNT('poitem'[po#]),
    ALLEXCEPT('poitem', 'poitem'[po#])
)

This calculated column computes the total count of each po# while grouping by the po# column and ignoring other filters in the table. Depending on whether you need a dynamic or static result, you can choose the appropriate approach.

Best regards,