Forum Discussion
Calculate Percentage on Matrix Column
I am trying to calculate the percentage of FMC i.e. 37/63 (FMC/OH) for every row and place that next to OH Column in this Matrix visual.
Note - OH is the total column which has been renamed as OH.
If any one can help, that would be greatly appreciated!
Regards,
Milan Khadka
Hi milankhadka83 ,
I've tried to create a simple sample using the fields from your data model.
Please let me know if anything is unclear.
I attach an example pbix file.
3 Replies
- DataNinja777
Super User
Hi milankhadka83 ,
It is simple to produce your required output in Power BI 😉. I've created a measure named OH and divided the measure FMC by it as shown below:
I attach an example pbix file.
Best regards,
Hi DataNinja777,
Thank you so much for your reply, however that's not the solution i am looking for because the data shown in Matrix table is based on multiple filter criteria, and it is also part of another table which has one to one relation. If you could help me with this, it would be great.
I was trying to attached a sample file, but seems like i dont have an option to upload a sample file.Please refer to the snips below for better understanding.
Desire Output:
Related Tables:
Data Sample:
Regards,
Milan Khadka
- DataNinja777
Hi milankhadka83 ,
I've tried to create a simple sample using the fields from your data model.
Please let me know if anything is unclear.
I attach an example pbix file.
