Forum Discussion
Solution Specialistwhere is my error
Man you r genuus.
you r right. Seriouslly your sight is perfect. in slicer I mistakenly change to greate than or equal to and thats because its made this issue.
now i changed to single value and now its perfectly working
thanks jihwan really you r genious.
Solution Specialist
sorry it want my fault i should give column name. here i attached the image. please have a look
Super UserHi, abc_777
I cannot see clearly but I guess your parameter's number is -10 (negative number), right?
- abc_777
yes. what ever number i give in -10 or -12 its not showing any value i check the formula servral time and compaire with your but couldd't found any error. even for quantity its working greate as i told you yesterday but same formula for sales its not working
- Jihwan_Kim
How does your [total sales measure] look like?
- abc_777
total sales measure =
SUMX('bm_all_cul bm_sales_dhk_all_cul',
('bm_all_cul bm_sales_dhk_all_cul'[SQty] ----- sold quantity
-
'bm_all_cul bm_sales_dhk_all_cul'[rQty]) -----return quantity
*
'bm_all_cul bm_sales_dhk_all_cul'[RPU])----- unit priceso get actual sale amount
global calendar table is connected i can confirmed you coz in same power bi file i can see quantity
is working with same calendar table but not sales
- Jihwan_Kim
Also, try to check if your calendar table is connected to your fact table.
Also, try to check if your calendar table is marked as a date table.
- abc_777
I know if I can upload the file that would be easy and effecient way to solve the issue but file is company data and file size is 54 mb. at this stage I am sorry as well. i hope you understand