Forum Discussion
Filter is not working with All SELECTED
Hi All, I need your help with dax powerbi. I have difficulty solving for this hours but couldnt solve I have measure which divides the sum of sku/total sum of sku to get the percentage. Mea...
Hi Anonymous ,
Let me know if this measures work.
Total SKU SUM DIST = SUM(Data14[TOTAL SKU Value])SUM SKU by Dist =CALCULATE(SUMX(Data13,Data13[SKU]),ALLEXCEPT(Data14,Data14[Distrubutor Name]))SKU Stock Contribution(%) = Divide([SUM SKU by Dist],[Total SKU SUM DIST],0)Data13 is ChartTable1 and Data14 is ChartTable2I added some more dummy values to validate my results and it seems to work fine.Regards,Harsh Nathani
