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.
Hi,
I have a calculated column and i want to create a measure on below condion.
measure= If (Calculated colum)=0, 0 , Calulated column/Totalsales.
Total sales is a measure.
How can i achieve this?
Please help.
Thanks,
Paruchuri
Solved! Go to Solution.
Hey,
basically you have to consider that there is something called Evaluation Context, this context has two aspects: Filter Context and Row Context.
Whenever you create a measure you have to consider the Filter Context (at least). Another thing that you to be aware of is the fact, that a calculated column is aggregated, by default the SUM aggregation function is used for numerical values.
Maybe this may work
a measure = var valueFromCalculatedColumn = CALCULATE(SUM('table'[calc column])) return IF(valueFromCalculatedColumn = 0 ,0 ,DIVIDE(valueFromCalculatedColumn,[Totalsales], BLANK()) )
Hopefully this is what you are looking for
Regards,
Tom
Hey,
basically you have to consider that there is something called Evaluation Context, this context has two aspects: Filter Context and Row Context.
Whenever you create a measure you have to consider the Filter Context (at least). Another thing that you to be aware of is the fact, that a calculated column is aggregated, by default the SUM aggregation function is used for numerical values.
Maybe this may work
a measure = var valueFromCalculatedColumn = CALCULATE(SUM('table'[calc column])) return IF(valueFromCalculatedColumn = 0 ,0 ,DIVIDE(valueFromCalculatedColumn,[Totalsales], BLANK()) )
Hopefully this is what you are looking for
Regards,
Tom
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |