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, 2020 in Power BI by anonymous
• 8,890 points
1,274 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, 2020 by Gitika
• 65,950 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
• 33,010 points
13,986 views
0 votes
1 answer
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
369 views
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, 2020 in Power BI by Gitika
• 65,950 points
155 views
0 votes
1 answer
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, 2020 in Power BI by Alisha
855 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
8,404 views
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, 2020 in Power BI by Gitika
• 65,950 points
2,584 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, 2020 in Power BI by Gitika
• 65,950 points
137 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,950 points
763 views