Reference or Calculate from unrelated dimension table

jnoel100 — Tue, 07 Nov 2023 14:52:18 GMT

Hi,

I need to reference the number of days from a calendar table to a measure.

The data model looks like this

Data is like this

Employee:

Employee	TeamID
ABC	1
DEF	1
GHI	2
JKL	3

Teams

TeamID	Team Name
1	Team A
2	Team B

Calendar - standard calendar table

The visual is like this
The value in the Matrix is a simple day count, and the matrix table is ignoring the "Team Name" slicer.

DayCount = CALCULATE(COUNTA('Calendar'[Date]))

I simplified it a bit but was really looking to reference the Calendar table for further calculations.

I understand that since the employee table and calendar table have no direct relation, it is repeating the values. But, is it possible to filter using the selected values from the Team slicer going to the matrix? So, the matrix would only show, Employees from Team A, or whichever is selected from the Team Name Slicer

Many thanks

Re: Reference or Calculate from unrelated dimension table

ThxAlot — Tue, 07 Nov 2023 15:20:45 GMT

= IF( NOT ISEMPTY( EMPLOYEE ), COUNTROWS( 'Calendar' ) )

Re: Reference or Calculate from unrelated dimension table

jnoel100 — Wed, 08 Nov 2023 02:56:48 GMT

Thank you that worked! It took me almost a whole day, searching and figuring out solutions, It looks so simple in hindsight.

topic Reference or Calculate from unrelated dimension table in DAX Commands and Tips

Reference or Calculate from unrelated dimension table

Re: Reference or Calculate from unrelated dimension table

Re: Reference or Calculate from unrelated dimension table