Forum Discussion
Advocate IDaily Average of Categorized Trouble Types
CrownWorker，
If you want to drag the measure to the existing Matrix visual you create, you can create the measure using DAX below, the measure value will be evaluated by each main category in your visual, and the measure value will be changed when you use slicers to filter the Matrix,.
Measure = CALCULATE(Count(Main_Table[MainCategory]))/[DateDiff]
If the above step still doesn't help, please post a screenshot about your expected result.
Regards,
Lydia
Advocate IMeasure = CALCULATE(Count(Main_Table[MainCategory]),ALLSELECTED(Main_Table))/[DateDiff]
This calculation in a format that wouls work for a column so that I can use it in a "Matrix" and when I filter by Date/Other filters all of the individual categories will update at once in the table. Right now if I try to use this it returns a value of "Infinity".
CrownWorker，
If you want to drag the measure to the existing Matrix visual you create, you can create the measure using DAX below, the measure value will be evaluated by each main category in your visual, and the measure value will be changed when you use slicers to filter the Matrix,.
Measure = CALCULATE(Count(Main_Table[MainCategory]))/[DateDiff]
If the above step still doesn't help, please post a screenshot about your expected result.
Regards,
Lydia
- CrownWorker
That worked perfectly, thank you very much and sorry for the late reply.