There isn't a general answer to your question. Humor in story stories and novels, regardless of genre, is a function of the author's sense of humor, and the traits of the characters in their stories.
By the function of the author's sense of humor, I mean that an author can only write humorously in the vain of their own sense of humor. An individual whose sense of humor is making puns, will probably only be adept at incorporating puns in their writing.
If a character needs to be ribald, then the author will include jokes of a sexual nature. They might range from crude to clever double entendres, again depending on character and situation.
Then there is the author's voice. The narrative may include jokes and witty allusions. These might leave some readers flat, and make others laugh every time they remember it. Douglas Adams and Terry Pratchett are authors that bring that type of voice to their stories. I am sure there are many others, those are just two I thought off. For me, I can remember Douglas Adams witticisms decades after I read them and still laugh.
So, for your story. You have to decide if you are including the spicy joke just because you like it and want to share it, or if it moves your story forward, or helps develop character.
If it fits the story, then the majority of people will take it for what it is. They may or may not like the joke, but its presence alone won't matter since its important to the story itself.
If on the other hand, you just want to write a naughty joke in your story, then it's hard to tell how people will react. They'll probably react stronger to a badly written story -- with or without the joke -- than to a well-written story.
But, intrinsically, there is nothing wrong with including blue humor in your stories -- short of limitations asserted by genre. Like YA typically doesn't read like Fifty Shades of Teenagers.