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

## Calculate user percentage from two sets of date filter

Hi,

I am a new into power BI.I have a table below(that has limited records here)

I have three datacards and two date filters like below

Please help me to resolve this.

Thanks

Vinoth SUSAINATHAN

1 ACCEPTED SOLUTION

Accepted Solutions
Senior Member

## Re: Calculate user percentage from two sets of date filter

Hi @Vinothsusai@vinoths

To be able to create your calculation you probobly need to duplicate your table and relate your date slicer 1 and card 1 to table 1 and repeat it with the second table, then you can create the measure I've posted earlier.

Regards,
Mariusz

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

8 REPLIES 8
Senior Member

## Re: Calculate user percentage from two sets of date filter

Hi @vinoths

You can use the following expresion.

```Measure =
100 * (
DIVIDE(
[Measure1], --this is where you insert your 52K Measure
[Measure2] -- this is where you insert your 32K Measure
) -1
)```

Regards,
Mariusz

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

Frequent Visitor

## Re: Calculate user percentage from two sets of date filter

Hi Marius,

Thank you very much for your reply.

How to create that 52K and 32K measure based on the date filters

52k -> 1st datefilter

32K -> 2nd datefilter

Do you have any idea about that please.

Thanks

Vinoth S

Senior Member

## Re: Calculate user percentage from two sets of date filter

Hi @vinoths

In the below measure you can use column instead of creating measures

```Measure =
100 * (
DIVIDE(
SUM(YourTable[YourColumn]), -- place inside of sum () the name of the column you used for 52K card
SUM(YourTable[YourColumn]) -- place inside of sum () the name of the column you used for 32K card
)  - 1
)```

Regards,
Mariusz

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

Frequent Visitor

## Re: Calculate user percentage from two sets of date filter

Hi Maruis,

Thank you.

Here I have used the same column for both field.

1st field based on 1st filter.

2nd field based on 2nd filter.

Do you have any idea please.

Thanks

Vinoth S

Senior Member

## Re: Calculate user percentage from two sets of date filter

Hi @vinoths

Can you provide screenshots of table(s) you are using in both Cards 33k and 52k and highlight the columns?

Many Thanks

Mariusz

Highlighted
Regular Visitor

## Re: Calculate user percentage from two sets of date filter

Hi Maruis,

I have used the same column for both data cards. Please see the below screen shots

Please advise.

Thanks

Vinoth

Senior Member

## Re: Calculate user percentage from two sets of date filter

Hi @Vinothsusai@vinoths

To be able to create your calculation you probobly need to duplicate your table and relate your date slicer 1 and card 1 to table 1 and repeat it with the second table, then you can create the measure I've posted earlier.

Regards,
Mariusz

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

Regular Visitor

## Re: Calculate user percentage from two sets of date filter

Thank you very much. It works fine.