NEWBIE HELP! Count of sites where audit score is more than or equal to . . .

[Luke_Howells]

Hi All,

Still new to all this, so hoping someone can help 😇

I am trying to get a count of the number of sites that have had an audit score that is less than or equal to 8.999.

I know its probably simple but I'm still learning all this and can't work it out. Can someone please help?

[v-alq-msft]

Hi, @Luke_Howells 

Based on your description, I created data to reproduce your scenario.

Table:

You may create a measure as follows.

CountAll = 
COUNTROWS(
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Audit Score]<=8.999&&
        'Table'[Audit Score]<>BLANK()
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Luke_Howells]

Hi @v-alq-msft , Thanks for your reply. It works great but I need a distinct count of the number of sites. I should have mentioned that each site is in the data multiple times. I know this would involve a DISTINCTCOUNT but I'm unsure how to incorporate this in 😕

[v-alq-msft · Accepted solution]

Hi, @Luke_Howells 

You may modify the measure as follows.

DistinctCount = 
CALCULATE(
    DISTINCTCOUNT('Table'[SiteName]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Audit Score]<=8.999&&
        'Table'[Audit Score]<>BLANK()
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Luke_Howells]

@v-alq-msft  That's great thank you for your help 😁

[amitchandak]

@Luke_Howells 

Try like

calculate(count(Table[Site_name]),Table[Audit Score]<=8.999)