How to calculate PowerBI DAX - Row wise division by measure

Question

I want to calculate with Power BI but unable to get DAX to perform vector/row-wise division.

For example, with this dataset:

Category Value

A 1

A 2

B 3

C 4

Tried SUMX and CALCULATETABLE functions but I believe I am missing something fundamental. Can anyone help?

Answer 1

As for your question, I think you're looking for

=[Value]/CALCULATE(SUM([Value]); ALL(TableName))

Of course, you can replace SUM([Value]) with a measure name too.