Using FILTER - same propagation need

Hi all, Could you please help me getting the outcome as follow below (picture)? Problem is I cannot set up a Calculated Field that will repeat Total Year Objective Billings in every PivotTable r...

Need Help

Sean
9 years ago
bajimmy1983

Okay I think this is it :smileyhappy:
GT. OBJ. BIL. EUR = CALCULATE ( SUM ( phasing[VALUE] ), FILTER ( ALLSELECTED ( phasing ), phasing[TITLE] = "OBJ. BILLINGS EUR" ) )
Result in PBI
And In Excel...

Hope this helps! :smileyhappy:
bajimmy1983
9 years ago
Sean,

I think I got it resolved. I am attaching SampleFile_v2.

Could you please check if Measures "Share Bil", "Share Cost" and "Share Margin Bil" are correct? In case you have a better solution I kindly ask you to share with us! :smileywink: :smileyhappy:

Now I have this point... If you look at the PivotTable in worksheet "BREAK_DOWN_Client" you will find:

Bill_Cost_Margin_Share_1
If I filter "AFFIPERF" in "PURE PLAYER" PivotTable column note that Shares (Bill, Cost and Margin Bil) get 100% (columns G, J and M).

Is there a way to show 50,39% for AFFIPERF even if it is filtered in PivotTable ROW or when it is filtered in Filter PivotTable section and avoid the picture below?

Bill_Cost_Margin_Share_2
Best regards,

bajimmy1983

Advocate V

9 years ago

Hello Sean, good morning.

Sorry, but as I am a Newbie right now, Filter Context is a little difficult to me right now. I am studing almost every day and trying to apply it as much as possible.

So, I have applied both Measures (with ALL and ALLSELECTED), but again we could not reach desire outcome. See result in Figure 1 and then what I need in Figure 2 (as examples).

Obs: Measures in Column C are just for DAX calculation and will not sit in PivoTable. Just to ilustrate to you.

WRONGRIGHT