Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
I need to make a measure which calculates like this: if column r =0, then Pardavimai DK+-50_5 else column[r].
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.
Sales is not a column it is a measure
what column is Sales based on?
would this work?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |