User Profile
alamhaz
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: Dealing with Measure Totals
Hi In my case its works only when i choose some dates or product filter but when i dont use any filter its not showing total values check the screen shot. measure is Avg Sale lost (total ) = IF(HASONEFILTER('Product Movement'[Date]), IF([Total Qty Diff Avg] > 0, [Total Qty Diff Avg] * [Avg Selling Price (PV)]),SUMX(VALUES('Product Movement'[Date]), [Avg Sale Lost]) ) Please helpSumX is giving wrong value
Hi I am calcultaing sum of the measure but its giving me wrong value, all meaure gives wrong value on row lelvel but one measure give me correct value when i filter with product, What i am doing is multplying total qty diff avg with avg selling price , i am getting correct result in Avg sale lost but its not giving total measure is IF([Total Qty Diff Avg] >0, [Total Qty Diff Avg] * [Avg Selling Price (PV)] ,BLANK()) after comupting this i am computing with sumx measure is Avg Sale lost (product ) = SUMX(VALUES('Product Movement'[Date]), [Avg Sale Lost]) and Avg Sale lost (total ) = SUMX(VALUES('Product Movement'[Prod Key Value]), [Avg Sale Lost]) both measure is not giving correct result even i tried in calculted column still getting wrong value. Check the Screen shotadding up measures but giving wrong values
Hi good day I have one measure and i want to add it up using one condtion but its taking wrong values check below Screenshot. as highlighted i should be 1 but its showing 14, same behaviour is showing in others as well but some of them are fine, below is the measure ss Please if anyone can help me i tried but cannot reslove it.
