Forum Discussion
Help with creating a Card which multiplys the count
Hello
First time posting on here hope someone could please help
I needed to show an amount in £ on a card in a dashboard which is a multiplication of the count
for examples I have a report which counts
Credit Notes by Account Manager name i would like to multiply the count by a figure in £
so for example
Joe Bloggs - 25 count of credit notes therefore would like a card to show (25 x 10) and show £250
Thank you and would really appreciate someones help
Hi Anonymous ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new measure to calculate the credit notes.
Count of note = DISTINCTCOUNT('Credit note'[Account Manager name])3.Create the new measure to calculate OLCS.
Count of OLCS = SUM('Credit note'[OLCS REF])4.Create the new measure to multiply the count.
Value of credit * OLCS = [Count of note] * [Count of OLCS]5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new measure to calculate the credit notes.
Count of note = DISTINCTCOUNT('Credit note'[Account Manager name])3.Create the new measure to calculate OLCS.
Count of OLCS = SUM('Credit note'[OLCS REF])4.Create the new measure to multiply the count.
Value of credit * OLCS = [Count of note] * [Count of OLCS]5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.