Help creating the following measures? Data Sample Included

[powerbinoobster]

So I have the following data. I filtered for Jan 2023 just for demostration purposes. 

I want to create a measure that counts all the Yellows in Date Originated. (count = 10)

Same data but filtered Date Released to Jan 2023(Demostration purposes).

I want another measure that counts rows of those in Status of Incorporated, accounting only for Date Released. (count = 32)

Goal:

I want to create a clustered column chart that has total yellows in one column(Measure 1) and total incorporated in another(Measure 2). 

How would I achieve this?

[Anonymous · Accepted solution]

Hi @powerbinoobster ,

Here I suggest you to create inactive relationships between 'Calendar'[Date] and 'Table'[Date Originated] & 'Table'[Date Released].

Sample:

Data model:

Measure:

Measure 1 = CALCULATE(COUNTROWS('Table'),USERELATIONSHIP('Calendar'[Date],'Table'[Date Originated]),'Table'[Priority] = "YELLOW")

Measure 2 = CALCULATE(COUNTROWS('Table'),USERELATIONSHIP('Calendar'[Date],'Table'[Date Released]),'Table'[Status] = "Incorporated")

 Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.