What is created by a calculated field that has a formula of SUM(Sales) / SUM(Profit)?
What is created by a calculated field that has a formula of SUM(Sales) / SUM(Profit)?
A calculated field with a formula of SUM(Sales) / SUM(Profit) generates a measure because it involves aggregate calculations. Measures typically represent quantitative data that can be aggregated, such as sums, averages, or ratios, which is exactly what this formula represents.
a measure
Anwser: A Not dimension (talkign here about measures/continuos) and no sets for sure
A : measure
A. A measure