Forum Discussion
Post ProdigyUse calendar's inactive relationship in matrix visual?
Hi olimilo
Yes, you can not change which relationship a plain Calendar[Date] field uses by default as it will always follow the active one but you can force matrix to use inactive Date Completed relationship. Measure - CALCULATE([Your Measure], USERELATIONSHIP('Data'[Date Completed], 'Calendar'[Date])). Since a matrix unlike your bar chart is not from field parameter's NAMEOF switching.
You can create measure with USERELATIONSHIP with respect to Date Completed instead of Date Received and rest in the report will be using active relationship
Post ProdigyWhat exactly is a calculation group? Do you mean a measure or some other thing?
Super UserCalculation groups are powerful tools which allow you to capture and manipulate the filter context under which a measure is executed. One common use case is to provide time intellilgence functionality for any measure in the model, e.g. to perform year on year comparison.
You can read more about what they are and how to create them at https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups .