Forum Discussion

harrinho's avatar
harrinho
Helper III
8 years ago
Solved

Multiple values were supplied - Error

Trying to sort out something very weird. I have a table called CDL_SVCS_Proj_Practice_Prod_Split which contains list of projects with more than one row for each projects. In order to remove the dupli...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    harrinho

     

    Try this

     

    Viz_Top_BU =
CALCULATE (
    FIRSTNONBLANK ( CDL_SVCS_Proj_Practice_Prod_Split[Viz Top BU], 1 ),
    FILTER (
        CDL_SVCS_Proj_Practice_Prod_Split,
        CDL_SVCS_Proj_Practice_Prod_Split[Project ID] = CDL_Project_Details[Project ID]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

harrinho

 

Try this

 

Viz_Top_BU =
CALCULATE (
    FIRSTNONBLANK ( CDL_SVCS_Proj_Practice_Prod_Split[Viz Top BU], 1 ),
    FILTER (
        CDL_SVCS_Proj_Practice_Prod_Split,
        CDL_SVCS_Proj_Practice_Prod_Split[Project ID] = CDL_Project_Details[Project ID]
    )
)
harrinho's avatar
harrinho
Helper III
8 years ago

That's amazing, it works. Thank you very much!