Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measures by classification

Hi Experts,   I have a question that struggle me for a time, would anyone can help me to solve? I would like to create 4 measures (It's 2 types of measure in fact)   Please find the raw sample f...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish_Mathur 

I would like to make this question simple, I now just want the Yellow part - A Only. 
such that the sum of amount will exclude those customers have both A and B. hope that you can help, many thanks!

 

Simon

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ashish_Mathur  

    You're so great! It's exactly what I want. a million thanks ^^

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      You are welcome.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Ashish_Mathur  

         

        Sorry, need your help again. 

        There is something strange in the real data, I'm not sure if the no. of record too big.

        I found that the slicer cannot take control. 

        For example. the amount of SGBM0000054 (204) should go to "A only" (A = "01", B = "02")

        as there is no amount for "02"
        but now it go to Mixed A. do you know what's the problem and how to fix it? 

         

         

        thanks a lot

        Simon