Calculate user percentage from two sets of date filter

[Anonymous]

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

[Mariusz]

Hi @Anonymous 

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.

[Anonymous]

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

[Mariusz]

Hi @Anonymous 

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.

[Vinothsusai]

Thank you very much. It works fine.

[Anonymous]

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

[Mariusz]

Hi @Anonymous 

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

Many Thanks

Mariusz

[Vinothsusai]

Hi Maruis,

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

Please advise.

Thanks

Vinoth

[Mariusz · Accepted solution]

Hi @Vinothsusai, @Anonymous 

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.