total table connect to the data table but doesnt filter

[jppuam]

Hello,

i've a table that was some data agregated of the rawdata table, but when i filter the slicer by direcao (field of the rawdata) it doesnt actualize the sum of the department that i've on the tabela_indicadores.

can you please help me ?

thank you very much,

JR

[v-piga-msft]

Hi @jppuam，

Based on the information, I cannot reproduce your scenario by my test. 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

I would appreciate that if you could share your desired output.

Best Regards，

Cherry

[jppuam]

Hello,

i've upload a pbix fle, and what i want is :

- i have a table for totals that i want to use in the total boxes on the top of the report (black with total values and red that change with the selections that i have on the left)

- other table with the rawdata that i use to filter the objects that i have in the middle.

but when i filter the first selection "Pilar" the red totals doesnt put the right values.

i thnik its something with the realtions between tables. can you help with this ?

thank you,

JR

[v-piga-msft]

Hi @jppuam,

Based on your information, if I understand your problem corectly that when you select the value in slicers left, the total value with red background cannot be filtered with the slicers? 

---

 but when i filter the first selection "Pilar" the red totals doesnt put the right values.

I cannot find the option Pilar in the slicers on the left of the report. 

Could you describe your requirement in more details?

If it is convenience, could you share your expected output?

Best  Regards,

Cherry

[jppuam]

thank you Cherry,

i was not able to reply to you, but i'll came back at the end of the day.

thank you for the help,

JR

[jppuam]

Hello Cherry,

if you filter on the 1 slicer with that as the value "1.2......" you can see that it not filter the data correctly because de red card "TOTAL OBJ" it doenst filter correctly the value in the table "tabela_Indicadores".

for example if you filter de department (direcao) "RS", it should put the value 3,3 M€ on the red card, but it put the sum of the all value of the department, that is 8,5 M€ (because that department also has a project in the pilar 2.2

i dont know if it was clear,

thank you,

JR

[jppuam]

Hello,

just to reponse to the message, i havent still received a reply to my problem.

thanks,

JR

[v-piga-msft]

Hi  @jppuam,

Sorry for the delay. 

However, I cannot find the pbix file you upload. Please share your pbix file to OneDrive or Dropbox and post the link here.

Best  Regards,

Cherry

[jppuam]

Can you see if you can do it now ?

https://www.dropbox.com/s/qum3w1ec38u5ns0/PTO2018%20vC_repartidos.pbix?dl=0