Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help - Measure to find difference

Community, I am having difficulty writing DAX to find the differnce between various test results. Seamed simple. Any help on the topic is apperciated.   Below is example data and what I would lik...
Need Help
  • Geradav's avatar
    Geradav
    7 years ago

    After looking at Anonymous , using the LOOKUPVALUE() function makes more sense

    Dif2 =
VAR vCurrentTestIDtoRef = 'Table1 (2)'[Test ID to Ref]
VAR vCurrentTestMap = 'Table1 (2)'[Test Map]
VAR vRefNum =
    LOOKUPVALUE (
        'Table1 (2)'[Data_Col],
        'Table1 (2)'[Test ID], vCurrentTestIDtoRef,
        'Table1 (2)'[Test Map], vCurrentTestMap
    )
RETURN
    'Table1 (2)'[Data_Col] - vRefNum
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Geradav ,

Works great, Thanks!!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Geradav ,

I have run into another issue with a real dataset I am working with. 

I need to sum the data_col before I can subract the "Test ID" from the "Test ID to Ref".

In the current configuration it is being averaged.

 

Any thoughts?

 

Thanks.