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

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
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