Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Struggling with grouping

I have a table that lists status history line items. It has columns called Status and Created On as well as a key field to relate it to another table. Status contains a unique value from the list: "P...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi, Anonymous 

    You could try this way that create a new manually entered table and keep the cross filter direction is "Both"

    And the total for it will give only first Sent.

    For example:

    so you need to use the measure as below:

    Measure = var _table=ADDCOLUMNS('group',"_value",CALCULATE(SUM(Basic[Value]))) return
SUMX(_table,[_value])

    here is sample pbix file, please try it.

     

    Best Regards,

    Lin

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous ,

No it will try to filter and give only first Sent.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel