Matrix: Count Text String in headers

[HenryJS]

Hi all,

I have the below measure in a matrix.

I would like to be able to 'Total' the count of "Yes" strings in the column and row headers.

Is this possible?

Timesheet? = IF(SELECTEDVALUE('Export Placements'[PlacementStartDate])<= MAX('Calendar'[Date]) && SELECTEDVALUE('Export Placements'[PlacementEndDate]) >= MAX('Calendar'[Date]), "Yes", BLANK())

[amitchandak]

Use filtered and when scope is not date and what you have row, use the count measure

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Count measure will same as yes measure but that will do sum

I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-y...

[HenryJS]

@Pragati11 

There would be counts of "Yes" where I have put red dots.

[v-frfei-msft · Accepted solution]

Hi @HenryJS ,

Here we go:

Measure = 
IF (
    ISFILTERED ( 'Table'[date] ),
    IF (
        ISINSCOPE ( 'Table'[sub] ),
        MAX ( 'Table'[y/n] ),
        CALCULATE (
            DISTINCTCOUNT ( 'Table'[sub] ),
            FILTER ( 'Table', 'Table'[y/n] = "yes" )
        )
    ),
    BLANK ()
)

Pbix as attached

[Pragati11]

Hi @HenryJS ,

Your query doesn't give enough details. Can you try sharing some data screenshots and the expected output screenshot?

Thanks,

Pragtai