Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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??
@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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |