Forum Discussion

MrAndrewth85's avatar
MrAndrewth85
New Member
3 years ago

Measure does not work with slicer.

Hi.   I have the following formulas to calculate the variation in the number of customers from one year to another:   Num Customers Last Year = CALCULATE (                                      ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

MrAndrewth85 , Make sure dim_date is used in slicer and visual as per need.  Join with Dim_date should be single directional and it should have all dates and marked as date table

 

Try LY like

  • Num Customers Last Year = CALCULATE (                                                                                                                                                           SUM ( FACT_Customers[Number of Customers]),                                                                                                                                           dateadd( DIM_Dates[Date], -12, MONTH) )  

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

MrAndrewth85's avatar
MrAndrewth85
New Member
3 years ago

Thanks for your answer, amitchandak!

 

At the moment, the solution you have given me has not worked. In the model, DIM_Date and FACT_Customers tables are linked by Date Key, so I think it should be enough for the slicer to affect the measurements, but it is not doing it, and neither did it with the calculation that you suggested me to do for customers LY. Let me understand a little more about being sure dim_date is used in slicer and visual as per need. Do you mean that I use it in the filter of each visualization?

 

Thanks again for your answer!