Forum Discussion
Resolver IMesure with SELECTED VALUE
1- Yes, its possible using "ALL" dax Function, follow the link to see the documentation: ALL function (DAX) - DAX | Microsoft Learn
2- Just create the measure where you'are calculating the SUM of you sales, if the date calendar and your sales are in the same table, when you put that column of date in a slicer the filter's will be calculated automatically. if are in diferent tables will work also, but you need to relate these tables.
Example:
Measure = SUM([Your_Column_Of_sales])
Super User1- Yes, its possible using "ALL" dax Function, follow the link to see the documentation: ALL function (DAX) - DAX | Microsoft Learn
2- Just create the measure where you'are calculating the SUM of you sales, if the date calendar and your sales are in the same table, when you put that column of date in a slicer the filter's will be calculated automatically. if are in diferent tables will work also, but you need to relate these tables.
Example:
Measure = SUM([Your_Column_Of_sales])
Resolver IThanks for your reply
For point 2:
Is it possible, for example, to calculate the sum of my sales according to the month preceding the date selected in my slicer?
If so, can you give me an example?
- Bibiano_Geraldo
Yes, it is possible, you can use the following code:
Note: Make sure to replace 'Calendar'[Date], with your column date, and [Total Sales] with your SUM of salesMeasure=Var salesPreviousMonth = CALCULATE([Total Sales], PREVIOUSMONTH('Calendar'[Date]))RETURNsalesPreviousMonth
if my reply help you mark it as solution.