Forum Discussion

mkurup12's avatar
mkurup12
Icon for Helper I rankHelper I
4 years ago

Distinct count when filtered with inactive relationship

Hi!   For this dataset, I added in a calendar table (using the calendar function which i called Date[Date]) and the payroll date and the date from the date table have an active relationship. The da...
Need Help
Show and Tell
Tutorial Requests
McDermoW5's avatar
McDermoW5
New Member
4 years ago

Hey mkurup12, 

can you send that first screenshot again? I can't seem to read any of the information in any of those tables. Best guess is to use the USERELATIONSHIP() function here to actively specify what relationships you want that measure to use. Also it would be great if you could show me what columns/measures you're using in the table showing the issue just to be clear on what you're wanting to display.