Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community,
I need the negative sign (-) in Pieces Out and Order shipped values to be removed. The total value displaying is not accurate as well.
See my measures formula:
Cheers.
Solved! Go to Solution.
Hi @Olumeedeh ,
Please have a try.
Create a measure.
measure=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Pieces Out])
return
IF(HASONEVALUE('table'[month]),'table'[Pieces Out],SUMX(_b,[aaa]))
measure_ordershipped=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Orders Shipped])
return
IF(HASONEVALUE('table'[month]),'table'[Orders Shipped],SUMX(_b,[aaa]))
I have also found a helpful post, please refer to it to see if it helps you.
If it does not help, please provide your pbix file without privacy information and more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Olumeedeh ,
Please have a try.
Create a measure.
measure=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Pieces Out])
return
IF(HASONEVALUE('table'[month]),'table'[Pieces Out],SUMX(_b,[aaa]))
measure_ordershipped=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Orders Shipped])
return
IF(HASONEVALUE('table'[month]),'table'[Orders Shipped],SUMX(_b,[aaa]))
I have also found a helpful post, please refer to it to see if it helps you.
If it does not help, please provide your pbix file without privacy information and more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you
Try like
sumx(Values(Date[Month]), Pieces Out = IF ( MIN ( 'Table Name'[Column] ) < 0, MIN ( 'Table Name'[Column] ), BLANK () ) )
Refer to video from Curbal- If needed
https://www.youtube.com/watch?v=ufHOOLdi_jk
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |