Fixed LOD issues in Powerbi

[Anonymous]

Hi,

I have to showcase result as below table. (This would be the output of the report)

Location	Jan	Feb	Mar	Apr
	Total   weekly>3	Total   weekly>3	Total   weekly>3	Total   weekly>3
Hderabad	100      23	120      35	160      23	100      23
Banglore	250    112	50        12	220    112	250    112
Chennai	120       43	170      43	123       43	120       43

By using  the data as below (Exacmple of the the data we have )

Locatin	access Date	empid	no.of rows
Hderabad	01/01/2020	1	1
Banglore	05/02/2020	2	1
Chennai	08/03/2020	3	1
Hderabad	08/01/2020	1	1
Banglore	03/02/2020	2	1
Chennai	04/03/2020	3	1
Hderabad	01/01/2020	4	1
Banglore	08/02/2020	2	1
Chennai	08/03/2020	6	1
Hderabad	08/01/2020	5	1

As per our requirement, we need to show the total number of employees per month per location. and the number of employees who have accessed >3 per week  and week<=3 in particular month per loaction.

I am getting the total count as we have direct count , and the second row week>3 I am not able to get the actual values. It is fine if we get the result as Monthly count>12. Here we are not showing the emp_id, but the aggregated value should be based on employee.

Can any one suggest an approch this requiremnent.

Thanks,

Madhav

[wdx223_Daniel]

sumx(values(empid),.....)

[Pragati11]

Hi @Anonymous ,

Have you tried creating a relationship between your both the tables on Employee ID or may be some other unique column?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 ,

Here we have only one table.. as shown in the second table in the post.. The first one is what we expect the result of the report.

Hope you understand.

Thanks,

Madhav