Calculate % of a column

[hans3400]

Hi

A brief explanation. Of all invoices made in a month, 95% usually is sent as a letter. I'm going to decrease that percantage to, let's say 70% and want to show the cost reduction each month. So I want a measure or column that calculates 95% of all invoices made in a month and then a column or measure theat shows the variance from the actual % of letters sent (70%.)

Table looks like this:

Date	Total invoices made	Invoices sent as letter
Jan/22	10000	9500
Feb/22	10000	8000
Mar/22	10000	7000

Hope it makes sense.

[v-yinliw-msft · Accepted solution]

Hi @hans3400 ,

You can try this method:

New a measure:

DEC =
CALCULATE (
    SUM ( 'Table'[Total invoices made] ) * 0.95
        - SUM ( 'Table'[Invoices sent as letter] ),
    FILTER ( 'Table', 'Table'[Date] )
)

The result is:

Hope these help you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hans3400]

Thank u so much for your help. It works as intended. Do u mind explaining what the last line does? "

 FILTER ( 'Table', 'Table'[Date] )

I'm pretty new to PBI, so try to learn as much as possible.

[v-yinliw-msft]

Hi @hans3400 ,

This filter is used to filter dates by group.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.