Forum Discussion

ajinkya1907's avatar
ajinkya1907
Icon for Helper II rankHelper II
8 years ago
Solved

Group BY related doubt

Hi,   I am using Cricket related data for one of my report. I would like to find out total centuries scored by batsmans. I am using below function but not getting desired results. Please help with ...
Dashboards
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    ajinkya1907

     

    Try this MEASURE

     

    Centuries =
VAR temp =
    FILTER (
        SUMMARIZE (
            'deliveries',
            'deliveries'[match_id],
            deliveries[batsman],
            "runs", SUM ( deliveries[batsman_runs] )
        ),
        [runs] >= 100
    )
RETURN
    COUNTROWS ( temp )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

ajinkya1907

 

Try this MEASURE

 

Centuries =
VAR temp =
    FILTER (
        SUMMARIZE (
            'deliveries',
            'deliveries'[match_id],
            deliveries[batsman],
            "runs", SUM ( deliveries[batsman_runs] )
        ),
        [runs] >= 100
    )
RETURN
    COUNTROWS ( temp )
  • ajinkya1907's avatar
    ajinkya1907
    Icon for Helper II rankHelper II
    8 years ago

    Zubair_Muhammad - You are Awesome !!!

     

    The solution worked absolutely fine. Thank you very much. This method will help me in many other calculations.

     

    Thanks to v-qiuyu-msft for your suggestion. It helped too :-)