SUM of Row Count by Column Value

[vbiqvitovs]

I've been trying to understand the DAX code required to build a calculated column that addresses count based on conditional formatting.

I have two tables, one table is acting as a summary table for FICO data for further analysis. The other table is the source table for the data.

I have a range value (FICO Band) for all rows in the source table. I would like to count (for total) the occurrences of each of one these values and import this count into the summary table via a calculated column named something like Count of FICO Range.

Entries in Source TableSummary Table

Any assistance in crafting the DAX for the calculated column would be appreciated.

[v-ljerr-msft]

Hi @vbiqvitovs,

According to your description, you can first create a relationship between your "Entries in Source Table" and "Summary Table" using "FICO" and "FICO Range" column. Then you should be able to use the formula below to create the "Count of FICO Range" calculated column in "Summary Table".

Count of FICO Range = COUNTROWS ( RELATEDTABLE ( 'Entries in Source Table' ) )

Regards

[Anonymous]

Hi @vbiqvitovs

If you create a measure that is CountofRows =  Calculate (Countrows(FICOBand))

and then plot FICO Range as the Axis and CountofRows as the Values you should get what you want.

If this olves your issue please accept this as a solution and also give KUDOS.

Cheers

CheenuSing