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,
Sean, sorry, I forgot to mention that [Bil BRL] is:
Bil BRL := SUM ( pipe[INVESTIMENTO LIQUIDO BRL] )
I can't duplicate what you are doing with the data I have (I've selected all - removed all filters)
Go in Excel and use the built-in Calculations to figure out what you need exactly % Of Row Total, % of Parent Row Total ect...
If you are lucky you'll need one of the first 3 - those exist in PBI! :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,
Hi Community.
Could anyone help me to resolve this little problem with a specific measure? You can replicate What I have according to SampleFile.
I am almost there (target), but this measure is not returning correct percentage for PURE PLAYER level in the PivotTable.
Please see an example as follow below. Red means wrong value measure is returning. I suspect the problem is at the final part, but I confess I cannot see a solution rightnow.
PURE PLAYER MONTH CLIENT Act Bil BRL Shr Bil Correct AFFIPERF 1.091.739 100,00% 49,00% JAN 241.157 22,09% 22,09% EMIRATES 132.263 54,85% 54,85% HYUNDAI - CAOA 50.471 20,93% 20,93% CAOA SUBARU 35.539 14,74% 14,74% GLOBO 20.182 8,37% 8,37% CLUB MED 1.702 0,71% 0,71% CETIP 1.000 0,41% 0,41% FEV 650.985 59,63% 59,63% EMIRATES 155.540 23,89% 23,89% GLOBO 152.464 23,42% 23,42% TIM 116.667 17,92% 17,92% CLUB MED 110.258 16,94% 16,94% FUTURA 83.306 12,80% 12,80% HYUNDAI - CAOA 23.000 3,53% 3,53% METRÔ RIO 8.750 1,34% 1,34% CETIP 1.000 0,15% 0,15% MAR 199.597 18,28% 18,28% TIM 83.333 41,75% 41,75% FUTURA 65.454 32,79% 32,79% EMIRATES 26.060 13,06% 13,06% HYUNDAI - CAOA 23.000 11,52% 11,52% METRÔ RIO 1.750 0,88% 0,88% SOCIALYSE 1.039.954 100,00% 46,68% JAN 420.489 40,43% 40,43% TIM 262.405 62,40% 62,40% DIA 55.626 13,23% 13,23% CAOA SUBARU 39.825 9,47% 9,47% HYUNDAI - CAOA 22.151 5,27% 5,27% HYUNDAI - HMB 15.940 3,79% 3,79% EMIRATES 9.811 2,33% 2,33% STARBUCKS 6.731 1,60% 1,60% FOX 5.000 1,19% 1,19% CLUB MED 3.000 0,71% 0,71% FEV 367.839 35,37% 35,37% TIM 162.438 44,16% 44,16% DIA 96.349 26,19% 26,19% CAOA SUBARU 30.100 8,18% 8,18% METRÔ RIO 28.412 7,72% 7,72% CLUB MED 23.726 6,45% 6,45% FUTURA 19.620 5,33% 5,33% EMIRATES 7.194 1,96% 1,96% MAR 251.625 24,20% 24,20% TIM 175.328 69,68% 69,68% DIA 27.800 11,05% 11,05% CAOA SUBARU 18.500 7,35% 7,35% (blank) 16.640 6,61% 6,61% EMIRATES 7.268 2,89% 2,89% METRÔ RIO 6.088 2,42% 2,42% MOBEXT 61.149 100,00% 2,74% JAN 32.597 53,31% 53,31% TIM 32.597 100,00% 100,00% FEV 28.552 46,69% 46,69% GLOBO 20.274 71,01% 71,01% EMIRATES 8.278 28,99% 28,99% ECSELIS 35.002 100,00% 1,57% JAN 1.002 2,86% 2,86% CETIP 1.002 100,00% 100,00% FEV 34.000 97,14% 97,14% METRÔ RIO 33.000 97,06% 97,06% CETIP 1.000 2,94% 2,94% Grand Total 2.227.844 100,00% 100,00% Measure I am using:
Shr Bil:=IF ( ISFILTERED ( Client[CLIENT] ); DIVIDE ( [Act Bil BRL]; CALCULATE ( [Act Bil BRL]; ALLSELECTED ( Client[CLIENT] ) ); 0 ); IF ( ISFILTERED ( 'date'[MONTH] ); DIVIDE ( [Act Bil BRL]; CALCULATE ( [Act Bil BRL]; ALLSELECTED ( 'date'[MONTH] ) ); 0 ); IF ( ISFILTERED ( 'group'[GRUPO] ); DIVIDE ( [Act Bil BRL]; CALCULATE ( [Act Bil BRL]; ALLSELECTED ( 'group'[GRUPO] ) ); 0 ); IF ( ISFILTERED ( PurePlayers[PURE PLAYER] ); DIVIDE ( [Act Bil BRL]; [GT Bil BRL]; 0 ); DIVIDE ( [Act Bil BRL]; [GT Bil BRL]; 0 ) ) ) ) )Thanks a lot in advance,
Community, could you please try to help?
Using the same SampleFile I shared yesterday, I am sharing now three prints. Wrong view and Expected ones. I think this helps you helping me.
Note that when I select all values in "GRUPO" slicer all works, but when I need to filter a specific one (eg: HMG) then the problem occurs.
Thnaks again in advance,
- Hi, anyone could please help me?