https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992876#M100747 <P>Thank you bro, it works, nb!&nbsp;</P> Thu, 29 Dec 2022 08:04:39 GMT HaiQuan 2022-12-29T08:04:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992580#M100732 <P>I have two tables, and the&nbsp;PrimaryKey&nbsp;is <EM>Class</EM>. I need a dax to calculate the sum of <EM>now</EM> divided by the sum of <EM>max </EM>when there is a filter <EM>Quarter</EM>.</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P> Thu, 29 Dec 2022 04:03:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992580#M100732 HaiQuan 2022-12-29T04:03:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992615#M100737 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="492123" data-lia-user-login="HaiQuan" class="lia-mention lia-mention-user">HaiQuan</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">ResultMeasure = CALCULATE ( DIVIDE ( SUM ( Table1[now] ), SUM ( Table1[max] ) ), Table1[class] IN VALUES ( Table2[class] ) )</LI-CODE> Thu, 29 Dec 2022 05:03:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992615#M100737 tamerj1 2022-12-29T05:03:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992876#M100747 <P>Thank you bro, it works, nb!&nbsp;</P> Thu, 29 Dec 2022 08:04:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-command/m-p/2992876#M100747 HaiQuan 2022-12-29T08:04:39Z