Dynamically Calculate Sum based on the filter

Hi vnaga85,

You have to create Measures to achieve this.

I am sharing a pbix file here.

You will find the measure in that. Please check.

If you feel my answer is helped you. Please give me one Like(kudo) to my answer and accept as solution.

Hope this help you Nagarajan.

Regards,

Mehbub - India

Hi,

This formula will work

=COUNTROWS(FILTER(SUMMARIZE(Data,Data[Product],"ABCD",SUM(Data[Rewardamount]),"EFGH",SUM(Data[Bill amount])),[ABCD]>[EFGH]))