Forum Discussion

New Member

4 years ago

Count rows for column combinations

I need measure for Deliveries table , wich counts rows for each combination 'New, Modified, Repeat' (Type, in matrix as row) and 'Roof, Wall, Floor, Stair' (Design, in matrix as column) in each cell,...

Need Help

v-zhangti

Community Support

4 years ago

Hi, YKarpenko

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance.

Best Regards

YKarpenko

New Member

4 years ago

v-zhangti I'm resolved this issue by creating next table:

DeliveriesCount = 
GROUPBY(
    FILTER(
        ALLSELECTED('Deliveries'),
        Deliveries[Days] <> "Late"
    ),
    'Deliveries'[Type],
    'Deliveries'[Design],
    'Deliveries'[CustomerOrderId],
    'Deliveries'[Days],
    "Count", COUNTX(
        CURRENTGROUP(),
        'Deliveries'[RelatedDesignId]
    )
)

Thank guys for your advices