Count rows for column combinations

Question

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, where data is, but ignore Days&nbsp;column context (in matrix as row). Table filtered by DeliveryDate column&nbsp;in related (many to one) table Surveys. In right table — what i have with&nbsp;COUNTROWS('Deliveries'), in&nbsp;left table — marked sample of&nbsp;expected result. Could you help me please?&nbsp;&nbsp;

ykarpenko · Answer

v-zhangti&nbsp;I'm resolved this issue by creating next table:&nbsp;DeliveriesCount = 
GROUPBY(
    FILTER(
        ALLSELECTED('Deliveries'),
        Deliveries[Days] &lt;&gt; "Late"
    ),
    'Deliveries'[Type],
    'Deliveries'[Design],
    'Deliveries'[CustomerOrderId],
    'Deliveries'[Days],
    "Count", COUNTX(
        CURRENTGROUP(),
        'Deliveries'[RelatedDesignId]
    )
)&nbsp;Thank guys for your advices

amitchandak · Answer

YKarpenko , In your, measure add removefilters(Table[Days]) 
&nbsp;
Assume you are using M1 measure in left
M2 = calculate([M1],removefilters(Table[Days])&nbsp; )
&nbsp;
&nbsp;

ykarpenko · Answer

amitchandak, thanks. I tried&nbsp;CALCULATE(&nbsp;COUNTROWS('Deliveries'),&nbsp;REMOVEFILTERS(Deliveries[Days])&nbsp;) (right table), but result the same as just with&nbsp;COUNTROWS('Deliveries') (left table). What I'm doing wrong?Example of expected result&nbsp;&nbsp;

anonymous · Answer

Table 1 being your deliveries tabletable 2 being your Days dimension table&nbsp;&nbsp;

ykarpenko · Answer

Anonymous&nbsp;result as in previous case. I tried&nbsp;CALCULATE(&nbsp;COUNTROWS('Deliveries'),&nbsp;ALLSELECTED(Days[Days])&nbsp;)

Forum Discussion

Count rows for column combinations

6 Replies

Related content

Combine Column

Combining Column Data

Total Count in Column

Combine columns into 1

Tables combine