Displaying a text column in a measure/matrix
Hello, I have a measure I am using in a matrix as kind of a summary for multiple companies. I am using switch for the column headers and then I have multiple different CALCULATION functions for displaying what I need. However I am having trouble displaying a column that is supposed to show the category for the companies. The data is text. I have tried SELECTEDVALUE and that works if I have slicer and pick that specific category but I want to show the matrix for all categories at the same time, any ideas? Thanks 🙂
Unable to display the sum of measure
The above image is just taken for reference but I want it to be seen as a visual table in Power BI I have a common company key from table1 and table2. I have subtracted the values of table1 and table2 and created a measure(difference). But there are at times table2 > table1, this picks up a negative value. In the end the total under "difference" is 100, but I want it to be the sum of (100 +200) which I am unable to do. I tried using ABS DAX function measure = ABS([Difference]), which does not affect the total since it takes the difference of 1250-1150 = 100. I tried using an if statement as well : IF( table2 > table1 , difference *-1, difference*1). since the total is not calculated in a vertical fashion, it takes the horizontal difference. Can anyone tell me how to get 300 here?
