Forum Discussion

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
6 years ago
Solved

Have distinct result after filter

Hello,

 

Is it possible to have distinct result after filter.

 

Here my case : 

 

I have an columne "Client Name" and i want to know the number of intervention that they had (with my colomne DateIntervention) in one years so i used the relative date filter  i succeeded to have an result but i want to have distinct result with the colomne name. how can i do that ?

 

I hope i was clear, i know my english is not that perfect, sorry for that.

if someone can help me , if you need more informations guys tell me.

 

Thanks for the futur answer.

Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi ItSupportElm 

    You can create a measure to count the rows for each id.

    Measure = COUNT('Table'[dateintervention])
    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ItSupportElm 

    As tested, i have distinct values on my table chart.

    Could you show screenshots to help me understand better about your scenario?

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • ItSupportElm's avatar
      ItSupportElm
      Icon for Helper III rankHelper III
      6 years ago

      thank you for your answer v-juanli-msft 

       

      Actually he didnt work for me, i think because DateIntervention is in differente Table that ClientName who is an differente table too.

      Do you have an solution for me, formule i can use or a trick to do ? 

      (I precise that i pick my data on database MySql server)

       

      You can see on the screenshot for exemple there 3 times Idclient : 6 , i just want to have one , i dont care about the dateintervention they keep. 

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi ItSupportElm 

        To get distinct client name, you could summarize the "dateinterview" column by selecting "earliest" or "last" or "count".

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ItSupportElm 

    Is this problem sloved? 
    If it is sloved, could you kindly accept it as a solution to close this case?
    If not, please let me know.
     
    Best Regards
    Maggie