Table visual displaying total but blanks in rows

[Aswin_unni]

Hi

I'm working on a table visual where I created measures for each columns to display count of accounts, opportunities , Market influenced accounts.

The values for market influence accounts measure under each stage blank but its total is being displayed.
the measure is made by referencing those from another table where they have some tag to be identified as market influenced.
I checked on the stage filter context in the measure and there is no error in referencing that.

There are no active relationship between the tables.

Measure used

Market influenced accounts =

CALCULATE( DISTINCTCOUNT(Opportunity_table[Accounts ID]),

FILTER( Opportunity_table , Opportunity_table [stage] IN {"S1","S2","S3"}
&& Opportunity_table[Accounts ID] IN ( SUMMARIZE (FILTER ( ACCOUNTS_TABLE, ACCOUNTS_TABLE[MKT_INFLUENCED] ="Y"),ACCOUNTS_TABLE[ACCOUNTS ID]))

))

Can anyone please help me with this issue??

[amitchandak]

@Aswin_unni , Try like

CALCULATE( DISTINCTCOUNT(Opportunity_table[Accounts ID]),

FILTER( Opportunity_table , Opportunity_table [stage] IN {"S1","S2","S3"}
&& Opportunity_table[Accounts ID] IN ( SUMMARIZE (FILTER ( allselected(ACCOUNTS_TABLE), ACCOUNTS_TABLE[MKT_INFLUENCED] ="Y"),ACCOUNTS_TABLE[ACCOUNTS ID]))

))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Aswin_unni]

Thanks for your suggestion Amit.

Tried using allselect but its not working.

What could be the possible reason why the measure displays value in total or a card but not in the rows of a  table?