Help with creating a Card which multiplys the count

[HAA1988]

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 

[Anonymous · Accepted solution]

Hi @HAA1988 ,

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.

[HAA1988]

[HAA1988]

in the screen shot I am trying to multiply the credit note amount x count of OLCS REF