Forum Discussion
Difference between two matrix columns
Hello everyone,
I am working with athletes times and in the "CRs" tab of the attached pbix. I am comparing an athlete's time against record times (effectively in my data set, record times have been created as if they were an "athlete's" time). So in reality my matrix is comparing the times between two "Athletes".
As you will see in the first Matrix I have created a conditional formating, to color in Green the fastest time (The slowest was supposed to be colored red, but it doesn't. I haven't figured out why it doesn't yet posted here ).
However, I also want to add a column that will provide the time difference [Record time] - [Athlete's time] to show how far away is the athlete from the record. I would like though to always substract the athlete's time from the record, in this example: [CWSC 9yo all time RC-Girls] - [MEO O]
As discussed record times are represented as times of an Athlete, however these "Athletes" are flaged as "Dummy"
e.g. [CWSC 9yo all time RC-Girls] has a flag DummySwimmer = True
So the calculation has to be: ["DummySwimmer's" time] - [Real swimmer's time]
I tried to resolve this following feedback from Ashish_Mathur provided here:
I have twicked this to my schenario creating the Measure: "Difference2", however I need help implementing the logic [Record time] - [Athlete's time] and not MAX(Value) - Min(Value) as it currently stands.
I would be greatful if you could help me resolve this
Kerk
pbix: https://www.dropbox.com/s/z5xhmh7fh9blwbo/SWM_TestDB_3.pbix?dl=0
