https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-quarter-data-based-on-a-month-selection/m-p/2129667#M48864 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="188484" data-lia-user-login="rmeng" class="lia-mention lia-mention-user">rmeng</a>&nbsp;<BR /><BR />Use the following measure:<BR /><BR /></P> <LI-CODE lang="markup">Event Quarter = CALCULATE( [# Events], REMOVEFILTERS('Calendar'[Year Month]), VALUES('Calendar'[Year Qtr]]) ) </LI-CODE> Tue, 12 Oct 2021 12:10:18 GMT Fowmy 2021-10-12T12:10:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-quarter-data-based-on-a-month-selection/m-p/2129596#M48862 <P>I need help to build a card or a table value when a month is filtered to show the value of all quarter not only the month selected.</P><P>&nbsp;</P><P>when I select 2021 September I need the September value that´s easy and correct but for Quarter 3 I need a value summing all 3 months of that quarter.</P><P>&nbsp;</P><P><img /></P> Tue, 12 Oct 2021 11:52:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-quarter-data-based-on-a-month-selection/m-p/2129596#M48862 rmeng 2021-10-12T11:52:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-quarter-data-based-on-a-month-selection/m-p/2129667#M48864 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="188484" data-lia-user-login="rmeng" class="lia-mention lia-mention-user">rmeng</a>&nbsp;<BR /><BR />Use the following measure:<BR /><BR /></P> <LI-CODE lang="markup">Event Quarter = CALCULATE( [# Events], REMOVEFILTERS('Calendar'[Year Month]), VALUES('Calendar'[Year Qtr]]) ) </LI-CODE> Tue, 12 Oct 2021 12:10:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-quarter-data-based-on-a-month-selection/m-p/2129667#M48864 Fowmy 2021-10-12T12:10:18Z