Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Query

Hi ..I am new to DAX ... Pls help me.... I have to get the difference of values based on two entries of the same column & time. How can I get the  difference of Telemetry values of SensorID 975425 & ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Okay, then you can modify your measure a bit;
    Difference=CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975425") - CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975424").


    Let me know if that helps.

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Anonymousin case I understood what you meant then if you use the measure that Anonymous sent you and put dates on the axis of the column you will get the differenct per each row in the table visual.
If you want to also see the values for each Sensor on the table you can also add 2 measures and them also to the table.
975425_Value = CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975425")
975424_Value = CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975424")



Showcase Report – Contoso By SpartaBI