Forum Discussion
Need help for SumProduct DAX
Hi blader1989 ,
Try this:Row Number = IF(HASONEVALUE('raw'[Product Name]),CALCULATE(DISTINCTCOUNT('raw'[Product Name]),'raw'[Product Name]<=MIN('raw'[Product Name])))Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group
HI Anonymous ,
Thank you so much, you has helped me to solve my problem nearly 90% percent. Now only the sumproduct left because I wrote a sumproduct in power bi like below but the result is not correct as my excel file. You will see the reason why I need the row number DAX.
sumproduct = SUMX(raw, [Distinct count customer that total sales large than 0] * [Row Number])
My expect It should be like this so could you please help me to solve my DAX? Thank you in advance. I already update the latest file from my link drive above.