Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
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.
Thank you very much. It works fine.
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
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
Hi Maruis,
I have used the same column for both data cards. Please see the below screen shots
Please advise.
Thanks
Vinoth
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |