Forum Discussion

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