Forum Discussion

jaco1951's avatar
jaco1951
Icon for Helper III rankHelper III
7 years ago

Another sub total issue

Hi   I have trouble getting the correct subtotal. I have a series of loans (factTable), which is linked to a security table (dimSecurity) distinct number for each facility. These facilities is t...
Show and Tell
jaco1951's avatar
jaco1951
Icon for Helper III rankHelper III
7 years ago

Thanks Greg.

 

I'm not sure how to make it work as the [Loan balance] data is coming from the factTable, Can I mix tables in the variable?

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi jaco1951,

Could you please share your pbix file if possible? You could upload your file to your Onedrive or Dropbox and send the link to me,

 

Regards,

Daniel He

  • jaco1951's avatar
    jaco1951
    Icon for Helper III rankHelper III
    7 years ago

    I made a workaround. It is tricky to recrate the dataset as it is very large in both amount of tables and rows of data. And all the data is sensitive.... Otherwise I would be happy to share it.

     

    Thanks anyway.

     

    Br Espen