Percentage betweent data in two cards which pulls from the same field (one filtered, one unfiltered)

[Sam-L]

Hello,

I'm trying to create a card that displays a percentage value between two cards, which pull from the same data field. The two cards show an overall total of data (which doesn't filter) and a total after filtering which filters based on various slicers.

Obviously the second card will change when filters are applied, but the first stays static.

Does anyone know of a way to display this?

Thank you!

[v-yangliu-msft]

Hi  @Sam-L  ,

I created the data:

Here are the steps you can follow：

1. Create measure.

Measure = SUM('Table'[amount])

Measure 2 =
SUMX(ALL('Table'),'Table'[amount])

The effect of the ALL() function is not affected by the slicer, so of the two cards, one is affected and the other is not.

2. Select Date as the slicer, measure and measure2 as card

3. Select the Text box in Insert to create a text box

4. Result:

When the slicer is selected, measure changes, but measure2 does not change

Best Regards,

Liu Yang

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

[amitchandak · Accepted solution]

@Sam-L ,

Measures

with Filter

M1= count(Table[Mission_accept])

Without filter 

M2 = calculate(count(Table[Mission_accept]), all(Table))

percent = divide([M1], [M2])