Forum Discussion
Impactful IndividualInclude several mesasures into one table
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
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.
Impactful IndividualAnonymous Thank you for your response. Let me try it and I'll come back with my feedback.
Best regards,
Fernando
Hi calerof
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou