Trying to build a doughnut chart based on a slicer

[RitaMunha]

Hi everyone,

I´m new at Power BI and I`m facing some problems. 

I want to build a doughnut chart based on a slicer date. I don´t know if it`s possible

Table 1

Employee Name	Date	Time Interval	Sign-IN	Points
Name 1	16/03/2020	WH	08:00 - 09:00	5
Name 2	16/03/2020	WH	08:00 - 09:00	5
Name 3	16/03/2020	WH	09:00 - 10:00	4
Name 1	16/03/2020	NWH	19:00 - 20:00	1
Name 2	16/03/2020	NWH	20:00 - 21:00	1
Name 3	16/03/2020	NWH	21:00 - 22:00	1
Name 1	17/03/2020	WH	08:00 - 09:00	5
Name 2	17/03/2020	WH	09:00 - 10:00	4
Name 3	17/03/2020	WH	07:00 - 08:00	3
Name 1	17/03/2020	NWH	19:00 - 20:00	1
Name 2	17/03/2020	NWH	20:00 - 21:00	1
Name 3	17/03/2020	NWH	21:00 - 22:00	1

Table 2 (dummy values)

Employee Name	Data A	Data B	Data C	Level
Name 1	A	D	G	AAA
Name 2	B	E	H	BBB
Name 3	C	F	I	CCC

Date

Date	IsWorkDay
16/03/2020	1
17/03/2020	1

Table 1 & Date have relation based on date

Table 1 & Table 2 have relation based on Employee Name

Calculated Column
IsWorkDay
Points - simple metric based on the Sign-In intreval hour, that returns points for each interval

3 Measures
Measure 1
Nº of reported days - returns number of days between first date and last date in the slicer

Measure 2
Average PointsFC per user = calculate(sum(Table1[Points for Commitment]);ALLSELECTED(Table1[Date]))/(MeasuresTable[Nº of reported days])
I know the problem is in the measure "nº of reported days" because i have done a test, replacing the measure with a number and the result is fine. The problem is that i would like to recalculate the average based on the days selected in the slicer

Measure 3:
Level Average - if function that returns a text based on the average PointsFC per user

Calculated Column
Level = [Level Average]
I`m only doing this because the chart doesn`t let me insert a measure

I have insert an auxiliar table in the dashboard to compare Level and Level Average. Level Average works fine with the slicer (date) but Level (the calculated column) doesn`t. I can only reach to a formula that gives me the total average based on all days in table 1

What do i need? I need to contruct a doughnut graphic
Number of employees by level

Is this possible or should i quite this view?

Thanks in advance
(hope it`s clear enough)

[v-lili6-msft]

hi  @RitaMunha 

you should know that:

1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

If you still have the problem, please share your sample pbix file and your expected output.

Regards,

Lin