Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate percent based on multiple columns

Hello,   Is it possible to calculate percentage when MARA-MTART, LOCATIONTYPE and LOCATIONID are the same - like the example below. So adding an extra column calculating the percentage where the t...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    IF the "Mat Nr Count" is a measure, you can modify M like this.

     

    Best Regards,
    Community Support Team _ kalyj

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

Fowmy's avatar
Fowmy
Super User
4 years ago

Anonymous 

Create a sample Power BI file with dummy data and share the link here. You can save in Google drive.