Forum Discussion
DAX - Max value from basepack
venug here is the measure for you
Measure 2 = MAXX ( SUMMARIZE('Table (2)', 'Table (2)'[Outlet],'Table (2)'[Basepack]), CALCULATE ( COUNTROWS ( 'Table (2)' ) ) )drop BasePack and this new measure in a table visual and you will ge the result. Would appreciate Kudos 🙂 if my solution helped.
venug here is the measure for you
Measure 2 = MAXX ( SUMMARIZE('Table (2)', 'Table (2)'[Outlet],'Table (2)'[Basepack]), CALCULATE ( COUNTROWS ( 'Table (2)' ) ) )
drop BasePack and this new measure in a table visual and you will ge the result. Would appreciate Kudos 🙂 if my solution helped.
parry2k thanks a lot for providing solution...
i have got solution like below sanp shot. almost i have got correct solution, need B3 max count as 1, but it's showing as 2.
can you please help on this..
Regards
Venu
In summarize take a distinctcount basepake. You need to give that col a name. Use that to take out your final outcome.
Look at my example
CALCULATE(COUNTX(filter(SUMMARIZE(Sales,'Date'[date],"s1",SUM(Sales[Sales Amount])),[s1]>120),[s1])You do not need filter here.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
