cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prasanthari
Frequent Visitor

Using same column for 2 slicer's to change a card value

Hi,

I have a table as below,

dealid            dealstage
1234            1st Interview

1234            2nd Interview
1432            1st Interview
1579            1st Interview

1579            2nd Interview
1123            1st Interview

1680            2nd Interview
1680            1st Interview
1414            1st Interview

1414            2nd Interview
1113            1st Interview
1251            1st Interview
1951            1st Interview

1951            2nd Interview
1001            1st Interview
1001            2nd Interview

Need to show, "Count of dealid moved from 1st Interview to 2nd Interview". Here there is 10 deals in 1st Interview and 6 deals have moved to 2nd interview. So, 10-6=4.
My dax:

COUNTROWS (
FILTER (
/* Distinct values of IDs */
VALUES ( 'bi_stage gs_staging_incremental_deals_dealstage'[dealid] ),
/* Keep only IDs which contains both type1 and type2 */
VAR _Types = CALCULATETABLE ( VALUES ( 'bi_stage gs_staging_incremental_deals_dealstage'[dealstage ] ) )
RETURN
CONTAINS ( _Types,'bi_stage gs_staging_incremental_deals_dealstage'[dealstage ], "1st Interview" )
&& CONTAINS ( _Types, 'bi_stage gs_staging_incremental_deals_dealstage'[dealstage ], "2nd Interview" )
)
)
Above dax works perfectly.


But other requirement is, need to show this in 2 slicer with same column "dealstage". I have many other dealstage, for now (Ex: 1st slicer as 1st Interview and 2nd slicer as 2nd Interview) and single card visual should show 4 and other visuals should not change.

Spoiler
NOTE: Count of dealid, where dealstage="1st Interview" to dealstage="2nd Interview" and dealid of 1st Interview = dealid of 2nd Interview.

I hope, question is clearly suggested. Please help me with this requirement.

Thank You

2 REPLIES 2
wdx223_Daniel
Super User II
Super User II

try to cut off the intersactions between 2 silcers and the visuals other than card.

lbendlin
Super User III
Super User III

for your example it doesn't matter if the deals were at stage 1 if all you want to know how many deals are now at stage 2.

Is your process linear or can stages jump a level, like from 1 to 3 ?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors