Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I need some help . I am building a comparative scenario between actual values and budget, and want to apply a percentage of variation on a specific item of my budget (it can be one or more items at the same time that can change).
I have just definied a parameter that I have applied to my measure "budget". The thing is that if I change the % on the parameter this apply on the wholle item's budget.
Do you know a DAX's technical to isolate the effect of the parameter's variation?
Hi @RaulPBI,
Please provide sample data and show us the expected result.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Sorry for that. Attached you can find what I want to do. If I choose a item for example "gastos de personal" and a percentage of variation, 3% in the example, I need that my budget (presupuesto) change only a 3% in that item, not in the whole.
I attached my DAX measures chain too, in order to explain better the issue. Hope it helps.
Hi @RaulPBI,
As there existing many table, column and measure names in the provided formulas in Spanish, I could not understand them well. Based on my assumption, you want to make the result of [Asignación presupuestaria] to be changed dynamically depending on slicer selection, right?
Maybe you can create an extra mesaure similar to:
Final Budget =
IF (
SELECTEDVALUE ( Medidas[Medidas] ) = SELECTEDVALUE ( Apuntes[NombreProyecto] ),
[Asignación presupuestaria],
[AnotherBudgetMeasure]
)
Regards,
Yuliana Gu
It is not what I need. What I want is that the combination between parameter (%variacion presupuestaria) and a selected "medida" affects only to that "medida" not the whole budget as you can see in the 1st image (after parameter). The 2nd one shows the situation without parameter which is the same as normal comparison with budget (without paratemer scenarios).
Hope it helps to clarify.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |