Count non-blank fields per row in a matrix visual

[Hadi-BA]

hey guys

how can I Count non-blank fields per row in a matrix visual?

I searched through net and suggestions were to unpivot the main dataset. however my dataset is ok and I used matrix to pivot and summarize data and I need to Count non-blank fields row-wise.

my matrix and desired column would be like below

	store1	store2	store3	stores which sold each product
product 1
product 2
product 3

[v-yiruan-msft · Accepted solution]

Hi @Hadi-BA ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Store which sell per product = 
VAR _pcount =
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Product] ), ALLSELECTED ( 'Table' ) )
VAR _tab =
    SUMMARIZE (
        'Table',
        'Table'[Store],
        "@count", DISTINCTCOUNT ( 'Table'[Product] )
    )
RETURN
    COUNTX ( FILTER ( _tab, [@count] = _pcount ), [Store] )

Best Regards

[lbendlin]

You get that automatically in the visual.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to 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.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...