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 all,
I would be very grateful if somebody can help me.
I have an issue when using function IF as follows:
'EQUITY AJUSTED = (SUMX(Global_Table;IF([Measure_1] > 0;
([Measure_2]*RELATED('Specific_Table'[Column_1]))+[Measure_1];
([Measure_2]*RELATED('Specific_Table'[Column_1])
My problem is the following:
I want to use the IF function ([Measure_1] > 0) over the subtotal (Measure_1) of the first level of the hierarchy, because such function IF has sense using it over the net subtotal, but not over the detailed accounts if I drill down in the matrix.
If I drilled down expanding the table (second level of the hierarchy), I can find several rows below with different figures (Measure_1) which may be higher or lower than 0. With my formula, I can see that my IF function is operating and calculating the result differently row by row (but It has no sense if it is not the net subtotal).
What is what I want to get?
If the net subtotal (Measure_1) is > 0; do for all rows ([Measure_2]*RELATED('Specific_Table'[Column_1])+[Measure_1])
Else; do for all rows ([Measure_2]*RELATED('Specific_Table'[Column_1])
Is it possible? Any alternative solution?
Thank you so much in advanced.
Regards
Solved! Go to Solution.
You may check if the posts below help.
You may check if the posts below help.
I think you have to use isfiltered or isinscope
refer :https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Thank you for the tip!
Using ISINSCOPE function, I think I am closer to the solution (thanks!), but I do not having yet.
This is is the progress:
I have identified with "TRUE" the level of the hierarchy in which I want to use the IF function.
Maybe, a solution would to calculate separately the net results of each measure for the "TRUE" level and afterwards do the IF function.
Thanks again
By the way, my current formula would be:
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |