Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with my Targets Values

Hello everyone,

 

I'm new on the forum and i come from France sorry for my bad english in advance.

 

Actually im a trainee in an American company and i have to create a Claims Dashboard on Power BI.

I am having difficulty building the structure in Power BI from the data... Because I have 1 table for Targets but when i try to put my field "Target" on the field target value on a gauge it is empty. I tried one measure but it's still not working...

I would need your help to unblock the situation and allow me to move forward.

 

I can share screenshots with you or even my .pbix

My measure not working : 



 

Thanks in advance for your time !

 

Need Help
Show and Tell
Tutorial Requests

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Are you comparing date with year, or both are year or date ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hey, thanks for your reply !
      Sorry but I didnt understand your question, I choose between 2 dates and I would like it to take the target value with the most recent date 


      (My targets aren't working i just put Nb of claims + 2)

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _min=MINX(ALLSELECTED('Table'),'Table'[date])
var _max=MaxX(ALLSELECTED('Table'),'Table'[date])
return
MAXX(FILTER(ALL('Table'),'Table'[date]>_min&&'Table'[date]<_max),[date])

    2. Result:

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Anonymous ,

      Thanks for your answer.
      But i didn't understand how it could help me because that's not what i want. For a Business Unit i want it target for the month selected on a gauge.

      Have a nice day !