I want to make some extra DAX operations based on slicers Power BI that I have already selected.
My table "HM POR EQUIPO" have these columns:
equip / Month name / HOROMETRO
004315 January 21
004315 December 350
004315 October 446
004315 November 413
Also, I have another table "RELLENOS" with a calculated column that has this operation:
HOROMETROX = SUMX(FILTER('HM POR EQUIPO', RELLENOS[cequipo]= 'HM POR EQUIPO'[cequipo]),'HM POR EQUIPO'[HOROMETRO]).
What I want to do is when I select, two values in my slicer January and December, The value of 'HM POR EQUIPO'[HOROMETRO] has to give me a value that is not affected by the month that I don't select.
- If I select January and December, the value of 'HM POR EQUIPO'[HOROMETRO]' should be 371 and If I select just January, the value should be 21. How I can do that?
Thanks a lot for your help.