Calculate measure by column value in Power BI

[Analitika]

Hello,

I have a table. I want to calculate a measure which checks if column A =0, the calculate(sales), else values comes from A column

How to implement this?

[Signore_Ands]

Hello @Analitika 

Could you add a Conditional Column, in the Query Editor, like this?

And then sum the new column?

Or am I missing part of the requirement?

[Analitika]

I need to make a measure which calculates like this: if column r =0, then Pardavimai DK+-50_5 else column[r].

[v-chenwuz-msft]

Hi @Analitika ,

If you want to judge the column r if equal 0, you need the measure of this column r. It may be sum('table'[r]) or max('table'[r]). In any case, fields in digital format must be the result of aggregation in the table visual.

Based on this. measure should look like this.

Measure = 

IF( SUM('Table'[r]) = 0 , SUM( 'Table'[Pardavimai DK+-50_5]), SUM('Table'[r]) )

Best Regards

Community Support Team _ chenwu zhu

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

[Analitika]

Sales is not a column it is a measure

[Signore_Ands]

what column is Sales based on?

would this work?

Calc_Sales =

VAR vColA = CALCULATE(SUM(Table1[Column A]), fiLTER(Table1,Table1[Column A]<>0))

VAR vColSales = CALCULATE(Table1[Sales], fiLTER(Table1,Table1[Column A]=0))

RETURN

vColA+vColSales