Forum Discussion
Measure value based on max date and filter
Here is my data
when I use 2019 and I have all selected in month filter- it gives me value for January which works fine because that's my max data limit for but when it in Feb it should change to Feb dynamically, that's one problem.
Second if user select from filter 2018 and all months selected, it should give dec count "31241" which is the max month, but in my case its giving sum of all 12 months, if its all months selected, I want max month count only, but if particular month selected then that month count.
please let me know a solution
6 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous,
From your description, it seemed that 41219 in june may be the max count? If so, you could try below measure:
Measure = CALCULATE(MAX('Table1'[Count]))Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
- v-danhe-msft
Hi Anonymous ,
Form your first post, the picture with [count] is a column:
With your last post, it seemed [CNTD GIN] as a measure?
Could you please offer a sample data to have a test or if your measure is related withe a column, could you please offer a full information(related sample data and formula with your measure) if possible?
Regards,
Daniel He