Forum Discussion
Divide specific values in matrix visual with total value
Hello Community, I have a matrix. I want to calculate weigth for all the months by dividing it with total value. The dax i am using is bgtw = DIVIDE(CALCULATE(SUM(LE[BU AM]),ALLSELECTED()),[...
The above mentioned issue was resolved. The dax used was allexcept and in the dax i mentioned all the column names which i used in the slicers. Hope this helps anyone else. Cheers!!!!!!
Hi Anonymous
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
No issues, I want the result fast what you suggested will take a lot of time. thanks for the help