Forum Discussion

Harish85's avatar
Harish85
Helper III
1 year ago
Solved

Required Dax formula for below table.

  HI All,   In the table 74k above columns ,if customer id is same(c240008470) for VTWEG 11 and 13 then we should show only 11 values. Please help with the formula    
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello Harish85,
    I have reproduced your scenario in Power BI Desktop using the sample data you provided. I implemented a DAX formula to filter the table as per your requirement showing only VTWEG 11 for CUSTOMER_IDs with multiple VTWEG values (e.g: 11, 13, 15), while keeping all rows for CUSTOMER_IDs with a single VTWEG value.

    I got the expected output based on your description:


    For your reference, I have attached a .pbix file containing the solution, including the sample data and the implemented DAX formula. You can download it, open it in Power BI Desktop, and explore the FilteredSalesData table to see the results.

     

    Best regards,
    Ganesh Singamshetty

Aburar_123's avatar
Aburar_123
Solution Supplier
1 year ago

Hi Harish85 ,

Could you mark my post as a solution if it solves your problem. so that other people also can refer it.

 

Thanks.

  • Harish85's avatar
    Harish85
    Helper III
    1 year ago

    Hi Aburar, thank you very much for  your time. in the below screenshot I marked yellow for customer ID which is repeating,for that VTWEG column has 11,13 and 15 values, but we should show only 11 columns ,same should be repeated for other customer id's also.