title: Power BI Drop Down selection does not affect Cards
body: <p>Power Bi Dropdown does not affect the card values. I have 4 cards and based on the drop-down selection I want all the cards to get populated but it does not affect all of them. If I chose a value from the drop-down then it should display the count in the given card and update the rest for example if one card value is 40 and another is 30 and it should reflect the change based on the selected value in the drop-down but the cards have no affect. Any ideas?</p>
  <p>Below are the 4 measures for the cards based on dropdown value selection.</p>
  <p>The drop-down contains the following.</p>
  <p>&quot;Role Addition / Test&quot;</p>
  <p>&quot;role removed / Test&quot;</p>
  <p>&quot;Role Change&quot;</p>
  <p>4 cards are below:</p>
  <p>RoleAdded = CALCULATE(COUNTROWS('Table'), SEARCH(&quot;Role Addition&quot;, 'Table'[Column],,0)&gt;0)</p>
  <p>RoleRemoved = CALCULATE(COUNTROWS('Table'), SEARCH(&quot;role removed&quot;, 'Table'[Column],,0)&gt;0)</p>
  <p>RoleChange = CALCULATE(COUNTROWS('Table'),'Table'[Column] = &quot;Role Change&quot;)</p>
  <p>Total Changes = [RoleAdded] + [RoleChange] + [RoleRemoved]</p>