Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 Table
Summary Table
Any assistance in crafting the DAX for the calculated column would be appreciated.
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
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