Forum Discussion

vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
6 years ago

Count Multiple Columns

Hi, Need help to count the part usage. Below is sample data,   Case_Number PartNumber_Part replace_1st PartNumber_Part replace_2nd PartNumber_Part replace_3rd PartNumber_Part replace_4th P...
Need Help
vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
6 years ago

az38 

Thanks. Nonetheless, the original data has 100s of different part number. Writing each "part number" in the DAX will be difficult or impossible.

 

Rgds, Vincent

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

vincentakatoh 

so, I think AlB solution would be the most appropriative to this case