Forum Discussion
Using FILTER - same propagation need
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:
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,
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:
Sean, Greg_Deckler, Mi2n and Community. THANK YOU SO MUCH for your patience :smileyvery-happy: :smileyvery-happy:
This is a wonderful platform to ask for help, share what you have learned and learn again!!
I am learning a lot here, with books and Youtube.
Thank you so much again for your time and commitment!