Measure Divide with Measure

[abatahir1]

I have measure A based on column x, and measure B based on column B. 

I want to get the %age of each item in visual for measure B with the total of Measure A. 

[Anonymous]

Hi, @abatahir1 

Have you solved your problem yet? If not resolved, can you provide example data and your desired output?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[danextian]

Hi @abatahir1 

Try this:

DIVIDE ( [Measure B], CALCULATE ( [Measure A], ALLSELECTED () ) )

This will divide the row value of Measure B for the column/columns added to the visual by the total row value of Measure A.

[abatahir1]

This removes MTD filter from the measure, May be this is because the date selection also in the same column

[girishthimmaiah]

PercentageMeasure =
DIVIDE(
[Measure B],
CALCULATE([Measure A], ALLSELECTED(TableName))
)