Measure breaks table relationships?

[Melissa]

Hi @JBright,

That’s because BLANK() results get omitted unless you select “show items with no data”

Here’s an example of where to find that option.

Isolate blank Customer Sales

@SamSPAIN, When you say “isolate” do you mean “not show” or “separate for additional analysis”? If the former, the easiest way to do this is in the Filter Pane - set your Sales measure to “is not blank” for the relevant visual, per the screenshot below: [image] Also be sure to leave “Show items with no data” unchecked. [image] Brian