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 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:
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.
I hope, question is clearly suggested. Please help me with this requirement.
Thank You
try to cut off the intersactions between 2 silcers and the visuals other than card.
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 ?
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.