Forum Discussion

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
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
Struggling with grouping.pbix37 KB

Anonymous

Not applicable

6 years ago

Would it be possible to do this by creating a new manually entered table as follows:

Category        Status
Awarded        Awarded
Sent               Awarded
Sent               Pending
Sent               Not Awarded
Abandoned    Abandoned

And then using the Category column as a column on the matrix visual and filtering for just Awarded and Sent? That way for the Awarded category it would just pull in the Awarded status, but for the Sent category it would pull in everything except for the Abandoned status?