Forum Discussion
How to create new table with data from another table using DAX
By the looks of it, you can use a simple matrix + measures or field parameters (for measures) to get the result you are expecting
We will be happy to help if you provide sample data and the calculations needed for each "column" in your expected outcome
Hi devenk2 , you don't need to write anything in DAX.
- Insert a matrix, and place field on your site as shown in the image:
Best Regards
I understand I can do this in a Matrix, but I need to create a new table so I can do further calculations on this dataset. I cannot do what I need to do with a matrix.
Sorry to ask, but what calculations do you need to do which cannot be done with the original table (which is the ideal layout for tabular models)?
I am calculating grades for each app based on the counts of the severities. Once I group the counts of each severity for each application, I can calculate the values below. I cannot do this with my current dataset.
App Critical High Medium Low Weighted Grade Count of Vulns Max Weight Average Weight Count Weight Total Grade App1 2 2 150 1 1088 155 11837.44 1557.653333 1686.4 15081.49333 F App2 2 1 2 27 5 293.76 38.655 1.35 333.765 D App3 1 1 1 16 3 174.08 22.90666667 0.48 197.4666667 B App4 1 1 1 16 3 174.08 22.90666667 0.48 197.4666667 B App5 1 1 1 16 3 174.08 22.90666667 0.48 197.4666667 B App6 2 1 2 29 5 315.52 41.51833333 1.45 358.4883333 D App7 5 6 3 1 125 15 1360 178.9583333 18.75 1557.708333 F App7 3 4 5 1 101 13 1098.88 144.5983333 13.13 1256.608333 F App8 1 1 2 1 33 5 359.04 47.245 1.65 407.935 E App9 10 10 10 1 260 31 2828.8 372.2333333 80.6 3281.633333 F App10 0 0 1 1 7 2 76.16 10.02166667 0.14 86.32166667 A App11 0 0 0 3 0 3 0 0 0 0 A+
