How to calculate PowerBI / DAX - Row wise division by measure?

0 votes

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?

Oct 8 in Power BI by anonymous
• 4,940 points
71 views

1 answer to this question.

0 votes

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.

answered Oct 8 by Gitika
• 50,500 points

Related Questions In Power BI

0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,490 points
9,849 views
0 votes
1 answer
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

answered Oct 27 in Power BI by Gitika
• 50,500 points
27 views
+1 vote
1 answer

How to resolve Power BI DAX Join error?

Sample Table Used Here: Table1: Partner_ID, User_Id Table2: User_Id, ...READ MORE

answered May 14, 2019 in Power BI by avantika
• 1,500 points

edited May 15, 2019 by Omkar 621 views
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24 in Power BI by Alisha
39 views
0 votes
1 answer
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

answered Oct 1 in Power BI by Gitika
• 50,500 points
234 views
0 votes
1 answer

How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

answered Oct 8 in Power BI by Gitika
• 50,500 points
32 views
0 votes
1 answer