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.
Lately I've been trying to make a vertical analysis without sucess. I've tried the following measures:
ReceitaOperacionalLiquida = calculate(sum(value),
filter( all( my_table ), [Level1] = "(=) RECEITA OPERACIONAL LÍQUIDA" ))
This variable would have to show how much Net Revenue each month-year has so I could use it to the next measure that will tell me the vertical comparison. The results where not the expected as shown in this picture:
In it I show you that the measure I created is not altering from month-year to month-year. Could anyone give me some hints in how to solve this?
Solved! Go to Solution.
In general, suppose you in your table you have another columns [Category] and [Date], you may modify your measure like below:
ReceitaOperacionalLiquida =
CALCULATE (
SUM ( my_table[value] ),
FILTER (
ALLEXCEPT ( my_table, my_table[Date], my_table[Category] ),
[Level1] = "(=) RECEITA OPERACIONAL LÍQUIDA"
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In general, suppose you in your table you have another columns [Category] and [Date], you may modify your measure like below:
ReceitaOperacionalLiquida =
CALCULATE (
SUM ( my_table[value] ),
FILTER (
ALLEXCEPT ( my_table, my_table[Date], my_table[Category] ),
[Level1] = "(=) RECEITA OPERACIONAL LÍQUIDA"
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |