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 all, I think I found the way but still need your help that how can I add the row number next to the column following by my hightlight yellow into this visual table?
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 Team
If 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