Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

Hello,   Here I have a few sample data.   C_ID C_PHONE B_POINT 16015 161622020 151.2176 60154 161622020 744.0992 60021 131619522 61.9386 60121 131619522 3452.1312 9243...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ryan_mayu ,Thank you for your quick reply, you are absolutely correct! I additionally thought of another method.

Hi abc_777 ,

The table data are as follows:

Please follow these steps:
1. Use the following DAX expression to create a column named ‘Min’ in ‘Tabelle1’

Min = IF(CALCULATE(MIN('Tabelle1'[B_POINT]),ALLEXCEPT(Tabelle1,'Tabelle1'[C_PHONE])) = 'Tabelle1'[B_POINT],"YES","NO")

2. Use the following DAX expression to create a table named ‘Table’

Table = SUMMARIZE('Tabelle1',[C_PHONE],"B_POINT",MAX('Tabelle1'[B_POINT]))

3. Use the following DAX expression to create a table named ‘Table2’

Table 2 = FILTER('Tabelle1','Tabelle1'[Min] = "Yes")

4. Fianl output

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    PBI file attached.  Remove the spaces from the last 2 numeric columns of your Excel file. 

    Hope this helps.

     

    • abc_777's avatar
      abc_777
      Solution Specialist
      2 years ago

      Hi Ashish_Mathur ,

       

      thanks for your reply. But with the given PBI file when i filter with one mobile number it shows me all three record of that customer. i want want mobile with which would be Max B_point and another mobile numebr that would be his lowest b_point

       

       

       

      thanks