Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |