Forum Discussion
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...
Hi Anonymous ,
IF the "Mat Nr Count" is a measure, you can modify M like this.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I can see your solutions works perfect on the dummy data - very impressive!
I do have one question as I've made a mistake when I did the dummy pbix file.
The "Mat Nr Count" is a calculated measure:
Mat Nr Count= SUMX (
VALUES ( MODELVIEW[LOCATIONID] ),
CALCULATE ( DISTINCTCOUNT ( MODELVIEW[MATNR] ) )
)
Is it possible to do the same but with this as the "Mat Nr Count" measure?
Once again: Thank you so much! 🙂
Once again: Thank you so much! 🙂
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.
Thank you very much! 🙂