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
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 price
so 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
Super UserHi,
Please show me your slicer.
I think there are two spaces.
One is showing -10, right?
How about the other?
I think.... selectedvalue is not working if your slicer is not selecting only one number.
If you do not want to change the type of the slicer, try to amend the measure using MIN, not selectedvalue.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
- abc_777
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.