Forum Discussion

DreDre's avatar
DreDre
Icon for Helper II rankHelper II
6 years ago

Difference between two columns that only contain text

I am attempting to create a comparison between two columns in a matrix, but I am hitting a wall. Here is some sample data: Source Leaving Day of Week Arriving Company A1 Phoenix Mon...
Need Help
syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
6 years ago

Hello, if I have understood your question properly, then here is a possible solution. Let me know if it helps. 
This is the sample table that I had taken from your question.



As for the calculation, I created 3 and inserted them into the regular table instead of the matrix table. 

 I created a measures for A1 & A2

A1 = CALCULATE(COUNT('Table'[Source]),FILTER('Table','Table'[Source] = "A1"))
A2 = CALCULATE(COUNT('Table'[Source]),FILTER('Table','Table'[Source] = "A2"))
 
Afterwards, I created calculation for the difference a follows, 
Differnce = [A1]-[A2]
 
And then I inserted the following into the table and it looks the the visual below, 
 
 

  • DreDre's avatar
    DreDre
    Icon for Helper II rankHelper II
    6 years ago

    The downside is that I would like to avoid a hard reference in the calc because the list of sources grows monthly, and I already have over 100. With the number of Arrival cities that there are a matrix made more sense so that we could see the totals side by side rather than stacked. If they were stacked you would have to keep scrolling up and down to find the difference or add another slicer and go city by city still. I had found this other thread that was doing something simillar, but I was not able to figue out the count with a column of text, I was thinking count, or counta, but neither worked (probably user error).

    Link: Other Forum Thread