Forum Discussion

chahineatallah's avatar
chahineatallah
Helper III
4 years ago
Solved

Implicit measures

Hello everyone

 

Am trying to see how many customers bought certain product ,which is cueso calabres, so i added customername, order id ,etc

and finally i filtered my visual to cueso calabres

why when i put count of customer name, its giving 91 & not 38 as with count of orderids, why they are not matching

i have a filter for only certain product, so both values should match , what i am missing here?

 

  • i figured it out, its relation problem , i changed it to both (bad practise i know but sometimes it helps)

5 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage

    Hi chahineatallah 

     

    A piece of good advice:

     

    Please for your own good and sanity, refrain from using implicit measures. Always, ALWAYS, create explicit ones.

     

    You'll thank me later 🙂 No problem.

    • chahineatallah's avatar
      chahineatallah
      Helper III

      hi 

      Yes i totally agree, am just trying to work it without dax, just by drag & drop, can you tell me what is the problem? why am not getting proper results at the total level, when my table is filtered to only one product

       

      • daXtreme's avatar
        daXtreme
        Solution Sage

        I don't think anyone can answer your question without actually seeing your data and digging into it.

  • Kaly's avatar
    Kaly
    Resolver II

    Hi chahineatallah ,

    Glad you solved the problem by yourself! If you don't have other problems, would you please mark your reply as the solution, more people who have the same requirement will find the solution quickly and benefit here. Thank you.

     

    Best Regards,

    Kaly