Dax Function help

[cottrera]

Hi community , I have a report with two table visuals
Fields Category , From , To , Ditribution are taken from a static table and Property Count is a this measure (shown below)

Property Count =

var _scores = SUMMARIZE('Disrepairs Score','Disrepairs Score'[UPRN], "Score", SUM('Disrepairs Score'[SCORE]))

var _count = SUMX(_scores, IF([Score] <= SELECTEDVALUE('Score Distribution'[To]) && [Score] >= SELECTEDVALUE('Score Distribution'[From]),1))

return

IF(_count = 0 , "Zero" , _count)

The next table is made of of fieldsUPRN, Org ID and Findings or Desktop reivew fields come from our Data warehousetable called Disrepairs Score.  The Score and Score Category are measures (shown below)

Score = SUM('Disrepairs Score'[SCORE])

Score Category =

CALCULATE(

    SELECTEDVALUE('Score Distribution'[Category ]

        ,blank ()),

         FILTER(  ALL( 'Score Distribution'),

            [Score] >= 'Score Distribution'[From] && [Score] <= 'Score Distribution'[To]))

I need help to create a measure that counts the various catergories from this field (Table 2)

So that I can display the results here on table 1

Thank you 

Richard

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...