Total of group with slicer

[maximd]

Hi all,

I would like to show a group count with working slicers.

The table contains a list of breakdowns

• Unique ID (ID)
• LiftID (Elevator) (The group to count)
• ...
• Field I need: The total of breakdowns for that LiftID (Elevator)

For each elevator, I should see the amount of breakdowns for THAT LiftID with the selected date-range filter applied.

Active slicer: Last 7 months

I know that slicers don't apply on calculated colums but how should I do this then?

I currently have a  second table with measure: (Aantal: 6) (Top - right)

Aantal = COUNT('F_DEPANNAGEANALYSE'[LiftID])

The third table: (Total: 33) (Bottom - right)

Total_Table = SUMMARIZE(KEEPFILTERS('F_DEPANNAGEANALYSE');'F_DEPANNAGEANALYSE'[LiftID];"Total";COUNT('F_DEPANNAGEANALYSE'[LiftID]);"Datum";COUNT('F_DEPANNAGEANALYSE'[CalDepOproepDate]))

 

In this case, the Total should be 6 times 6 because the LiftID stayed the same.

Thanks in advance,
Maxim

[v-yuta-msft]

@maximd ,

Power bi doesn't support dynamic calculate column/table. If possible, could you share some sample(Please do not post the original data) and clarify more details about your requirement?

Community Support Team _ Jimmy Tao

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

[maximd]

@v-yuta-msft 

Here is some sample data:

ID	input date	executed date	liftID	liftname	reason
1	20/01/2020	31/01/2020	1	Building-locationname	button not working
2	25/01/2020	28/01/2020	1	Building-locationname	cable broken
3	20/01/2020	31/01/2020	1	Building-locationname	other reason
4	25/01/2020	28/01/2020	2	Appartment-location2	some reason
5	25/01/2020	31/01/2020	2	Appartment-location3	nothing special
6	20/01/2020	28/01/2020	3	House-locationname	power down
7	20/01/2020	28/01/2020	3	House-locationname	bulb broken
8	30/01/2020	31/01/2020	3	House-locationname	don't know
9	20/01/2020	28/01/2020	3	House-locationname	not fixed yet
10	20/01/2020	31/01/2020	4	Another-locationname	new motor

Schema:

[v-yuta-msft · Accepted solution]

@maximd ,

Create a calculate column.measure using dax below:

total/liftID =
CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[liftname] ) )

Community Support Team _ Jimmy Tao

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