Forum Discussion

silkwire's avatar
silkwire
Frequent Visitor
7 years ago
Solved

Calculate() - Issue filtering related table

Hello -    I have two tables: tblProject and tblAllocation                   tblAllocation stores all information relevant to a monthly allocation in relation a project. Each record...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi silkwire ,

    I have a little confused about your requirement.

    By my test with your sample data and your measure, it seems that the  result of measure is 39% as your desired.

    Do I missing anything? 

    Best Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi silkwire ,

I have a little confused about your requirement.

By my test with your sample data and your measure, it seems that the  result of measure is 39% as your desired.

Do I missing anything? 

Best Regards,

Cherry

 

silkwire's avatar
silkwire
Frequent Visitor
7 years ago

Thanks for the reply. I did the same thing as you and it worked... then I realized that there was a page filter set in the report I was working in that filtered out all false values. So, problem solved. Thanks.