Forum Discussion

calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Include several mesasures into one table

Hello, I'm trying to perform the easiest process in Excel where you take several measures and put them together into one table like this: The first Total in column P is a measure with this co...
Need Help
  • calerof's avatar
    calerof
    5 years ago

    I'm closing this post and will check the data model and the fact table to improve it. Thank you for any help provided.

    Fernando

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi calerof ,

 

I would say it's easy in Power BI as well. 🙂

 

So measures are never at a table/dataset level. They are at a data model level. You can access any measure from any table in other table.

 

So basically, in TABLE1 you can create a measure that adds up all the measures coming from TABLE2 and from TABLE3.

 

Hope this helps.

 

Thanks,

Pragati

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi Pragati11 ,

    Thanks for your response. But I need the granularity, I need to show basically each column from the first table, i.e. NoTRS with each category: AMOL, AP, CM, etc, and TRS and NoCAL, and then the Grand Total. 

    F

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi calerof 

      I think you want to show two matrix visuals in one like Excel.

      You can build a new table (By merge)then pivote them or build five measures (AMOL, AP, CM, PO, PP and add these measures like NoTRSDerTotal, TRSDer% into values in matrix).

      You may refer to this post: How to Subtract Data From Same Column In Imported Table When Put In Matrix?

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

       

       

      • calerof's avatar
        calerof
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        Anonymous Thank you for your response. Let me try it and I'll come back with my feedback.

        Best regards,

        Fernando