cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinoths Frequent Visitor
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)

5.png

I have three datacards and two date filters like below6.png

Please help me to resolve this.

 

Thanks

Vinoth SUSAINATHAN

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Mariusz New Contributor
New Contributor

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
Mariusz New Contributor
New Contributor

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.

 

vinoths Frequent Visitor
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

Mariusz New Contributor
New Contributor

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.

vinoths Frequent Visitor
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.

5.png

6.png

Do you have any idea please.

 

Thanks

Vinoth S

 

 

Mariusz New Contributor
New Contributor

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

Vinothsusai Regular Visitor
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

7.png

 

Please advise.

 

Thanks

Vinoth

Highlighted
Mariusz New Contributor
New Contributor

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.

Vinothsusai Regular Visitor
Regular Visitor

Re: Calculate user percentage from two sets of date filter

Thank you very much. It works fine.