Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Card - filter values

Hello everybody, I'm completely new to Power BI and I'm trying to build up my first report.   My problem is the following one: How can I make indipendent different "cards" when the result of the q...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous 

     

    If you want to the other card won't change when drill-through is that use the measure to display result.

     

    for example, i want to calculate the sum of group a values, i use this measure

    card1 =
CALCULATE( SUM( table[values] ), FILTER( ALL( table ), [group] = "a" ) )

    with this measure , this result will always calculate the group a even if you drill through the group b.

    if you have some difficulty to do this ,please provide some example date in the pbix file. i will help you.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous 

 

If you want to the other card won't change when drill-through is that use the measure to display result.

 

for example, i want to calculate the sum of group a values, i use this measure

card1 =
CALCULATE( SUM( table[values] ), FILTER( ALL( table ), [group] = "a" ) )

with this measure , this result will always calculate the group a even if you drill through the group b.

if you have some difficulty to do this ,please provide some example date in the pbix file. i will help you.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.