Remove data

[whygeent]

hi, im having a trouble regarding this visual. is this possible to remove the columns in red circle highlights and keep only the total (last column) in the visual? i don't need the values of plate number per column and i just need the total but it was distributed per column. thank you!

[Anonymous · Accepted solution]

Hi  @whygeent ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

You can try using a new table instead so that you don't have duplicate MEASURES, because the columns of the matrix are sorted alphabetically by default, and if you want to be sorted to the back, you can prefix it with a letter that is later in the alphabet

Table 2 =
var _table1=
SUMMARIZE(
    'Table','Table'[Group1],
    "Group2","E_Count Plate Number",
    "Amount",[Count Plate Number])
return
UNION(
    'Table',_table1)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[danextian]

Hi @whygeent ,

You can write a measure to show only the totals. Try either.

=
IF (
    NOT ( HASONEVALUE ( data[row field] ) )
        && NOT ( HASONEVALUE ( data[column field] ) ),
    [total]
)

=
IF (
    ( HASONEVALUE ( data[column field] ) )
        || NOT ( HASONEVALUE ( data[row field] ) ),
    [total]
)

What this does is it checks if there is more than one distinct date values  in a given filter context (eg  how many dates are there in a given date which obviously is just one).  If there's only one date then it returns blank otherwise the total. The same goes for the column. Alternatively, you can play around with the values formatting so the font color matches the row background's.