Forum Discussion
Responsive ResidentTop 3 Consecutive Selling Months DAX Help
Hi IamTDR,
Based on my test, it could work on my side, could you please offer me your data file and also you could download my sample pbix to have a view.
Regards,
Daniel He
Microsoft EmployeeHi IamTDR,
Based on my test, you could create a new formula:
Max Value = IF([Measure]=MAXX(ALL('Table1'),'Table1'[Measure]),[Measure],BLANK())
Result:
Regards,
Daniel He
Responsive ResidentThanks again for the help. I tried adding this measure to my report and only received blank results. I downloaded your example and added the measure to your report and it worked. Played around with it a bit and I now believe the issue is that with my actual data I have loads of different ISBNs not just one. When I added additional ISBNs to the sample data in your report, the measure proceeded to no longer work.
In the meantime I am trying to do the calculation now via SQL and then import the results via a table. Maybe my best case workaround.
- v-danhe-msft
Hi IamTDR,
Based on my test, it could work on my side, could you please offer me your data file and also you could download my sample pbix to have a view.
Regards,
Daniel He
- v-danhe-msft
Hi IamTDR,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
- IamTDR
Sorry for the delay in response. Yes I was finally able to get your method to work! Thanks again for all the aid.