topic Re: Unable to slice the data at quarter level. in DAX Commands and Tips

Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 17:58:10 GMT

I have a master table that has the list of JIRA items information. (Created date, closed date, status, created by etc). I have a date table created and connected to the master table. Date table has the columns for month, year and quarter. I am trying to get the count of JIRA items opened at a quarter level. SO created a measure using countrows(mastertable). I am then trying to slice the measure by using the Quarter column from the Date table using a matrix visual, but I am always getting the total count and not at the Quarter level.

Re: Unable to slice the data at quarter level.

tamerj1 — Tue, 02 Apr 2024 18:35:07 GMT

Hi deepak_d03

connected via which column?

Re: Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 18:45:17 GMT

the date from the date table and the created date from the master table

Re: Unable to slice the data at quarter level.

tamerj1 — Tue, 02 Apr 2024 19:21:52 GMT

deepak_d03

Please make sure the relationship is set to active and that you are using the correct columns from the correct tables.

Re: Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 19:35:45 GMT

relationship is active and columns too are correct. IS there anything else you can think of why it doesn't work? The data and tables are in another laptop so I cannot really put it here.

Re: Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 19:56:44 GMT

The quarters I created from the date table are Q1-23, Q2-23, Q3-23, Q4-23 and Q1-24. I have these as the rows for the matix visual but then only the columns name 'Quarter' is displayed. I expected 5 rows for the above quarter values.

Re: Unable to slice the data at quarter level.

tamerj1 — Tue, 02 Apr 2024 19:57:59 GMT

deepak_d03

Either the the measure refereces the wrong tsble or the quater column placed in the matrix is from a wrong table or you are placing a totally wrong measure. Nothing else I can think of.

Re: Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 20:20:22 GMT

If I drag the quarters column first, I can see 5 rows. But when I pull the measure to the values field, thats when the 5 rows vanishes. So I guess the measure (COUNTROWS('final') - 'final' is the other table having all the master data. ) isn't compatible here? The problem could be the way the measure has been defined?

Re: Unable to slice the data at quarter level.

deepak_d03 — Tue, 02 Apr 2024 20:38:16 GMT

tamerj1 - The 'final' table is the resultant of appending 2 other tables. So the data model has a 1:1 relationship between these tables. Not sure if this creates any issues here. Please suggest.

Re: Unable to slice the data at quarter level.

tamerj1 — Tue, 02 Apr 2024 21:14:20 GMT

deepak_d03

Check the data type of both date columns in both tables.

Re: Unable to slice the data at quarter level.

deepak_d03 — Wed, 03 Apr 2024 02:31:17 GMT

tamerj1 - They are both the same.