Forum Discussion

PwrBI01's avatar
PwrBI01
Icon for Post Patron rankPost Patron
5 years ago

Measure doesn't work correctly with slicer

Hi guys,   I am trying to create a forecast for a period not ended. The measure is the next one: Forecast = (Sales 12 last months / Sales 12 previous months * Total sales previous year) - Year-to-...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share the link from where i can download your PBI file.

  • PwrBI01's avatar
    PwrBI01
    Icon for Post Patron rankPost Patron
    5 years ago

    Hi Anonymous and Ashish_Mathur, 

     

    Thank you for your answers.

     

    I send you the link where the Power BI file is located so you can download it.

     

    https://drive.google.com/file/d/1qRQ4cGYELIraQ1IzhVXeNsiCJZO46U-r/view?usp=sharing

     

    I have created 2 columns, one for the results I obtain when I put the measure on a target and another column for the results I get when I filter the same measures for the year 2019 (I think this are the results the chart is showing) for trying to help you to understand.

     

    Thanks in advance.

     

    Regards.