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

Harish85's avatar
Harish85
Helper III
1 year ago

Sorry your formula is working there is a small change in the requirement, below is the example ,in below table there are three rows, but we should shown only VTWEG 11 VALUES.

ZZ_KUNAGVKORGVTWEGZZ_PARTNER_TYPECUSTOMER_ID
C240011427240111REC240011427
C240011427240113REC240011427
C240011427240115REC240011427
Aburar_123's avatar
Aburar_123
Solution Supplier
1 year ago

Hi Harish85 ,

Please try with the below calculated column that helps to choose the minimum VTWEG value.

Required Value Flag =
var min_value = CALCULATE(MIN('Table'[VTWEG]),FILTER(ALL('Table'),'Table'[ZZ_KUNAG]=EARLIER('Table'[ZZ_KUNAG])))
return if('Table'[VTWEG]=min_value,1)

 

Thanks.