Forum Discussion

Jensej's avatar
Jensej
Helper V
5 years ago
Solved

Using values from a Visual filter in a measure

Hello!    So i have a yearly Target Amount stored in a table. 15 780.-   Now i have a visual where my target value is 15 780.-. In my visual im able to filter the months if i for example want to ...
Need Help
  • darentengmfs's avatar
    darentengmfs
    5 years ago

    Jensej 

     

    I apologize for the misplaced " in the formula.

     

    Before you create the date column, click on Month, change the data type to text. Same thing goes to year. Then, you create the date column, after that, change the data type of the date column to date.

darentengmfs's avatar
darentengmfs
Post Prodigy
5 years ago

Jensej 

 

Is the relationship between the months table and the amount table defined?

  • Jensej's avatar
    Jensej
    Helper V
    5 years ago

    Hi darentengmfs 

     

    No it's just a table with single budget amounts without any other information ( No dates ) 

     

    Like this: 

    Apples | Pineapples | Pear

     300     |       700      |   450

    • darentengmfs's avatar
      darentengmfs
      Post Prodigy
      5 years ago

      Jensej 

       

      If your data does not have date values or anything that is related to dates, Power BI will not know what dates those are in.

       

      • Jensej's avatar
        Jensej
        Helper V
        5 years ago

        darentengmfs  I understand but isnt possible at all to see what i choose in the Visual Filter and use these inputs in a measure? 

         

         

         

        Measure  = 

        Variable = Target/12

         

        CALCULATE( SUM(SELECTEDMONTHS)*Variable)

         

         

        Something like this