Forum Discussion

powerbinoobster's avatar
powerbinoobster
Helper I
3 years ago
Solved

Help creating the following measures? Data Sample Included

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?

 

Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.