I have table like below
And I have calendar filter.
Here I need to find the count of eligible product based on the following condition for selected month
Condition is Rewardamount > Billamount then the production eligible.
For example if choose month 1 and 2 then it has to calculated something like this
Product A = (100 + 40) > (60 + 70)
Product B = (50+20) > (70 + 60)
Product C = (100+60) > (60 + 70)
The result should be 2, because product B is not eligible as per the condition. I need to calculate in this way dynamically.
Please someone help me on this.
Thanks in Advance
Go to Solution.
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.
Mehbub - India
View solution in original post
This formula will work
This is perfect.
Thanks a lot
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!