Power BI DAX Measure based on Slicer

Question

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.

For example: 

• 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.

Answer 1

How to use DAX Measure based on Slicer in Power BI

To perform a DAX calculation based on slicer in Power BI, you have to do the following:

1. Create a relation between the first and second table.

2. In the second table, Instead of creating a calculated column, you have to create a measure with the below simple formula

    HOROMETROX = CALCULATE(SUM('HM POR EQUIPO'[HOROMETRO]))
   

3. Add a slicer with Month Name from the first table.
4. Try to filter now with two selections that should be calculated as expected in the second table.
   

---

See Also

• Power BI calculated column based on Slicer
• Power BI measure based on slicer
• Power BI: Custom Column Vs Calculated Column

Comments

Thanks a lot

---

Hi @EliasCoronado, Don't forget to upvote and mark the answer as accepted in case it helped you!