Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
3 years ago

Dax Function help

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

Need Help

1 Reply