Forum Discussion

Emmy66's avatar
Emmy66
Helper V
5 years ago

dynamic dimension

Hi,  Below are some of the steps I've taken and got stock in step 3   Step 1 - I created a Metric Selection table as per below   Step 2 – I created the measure: Metric Selected = SELECTEDV...
Need Help
Emmy66's avatar
Emmy66
Helper V
5 years ago

Thanks Anonymous for your reply. Much appreciated. I hope the information below will help. The measures I included are currently calculated from 2 tables in the model (Object & User table) 

Sample measures: There are 5 other measures but the follow similar rule.

These are all based on the date slicer selection

Overdue_Projects =

VAR Selecteddate = SELECTEDVALUE(Dates[Date])

RETURN

    CALCULATE(

        COUNT(Object[proj_id]),

            FILTER(Object, Object[target_date] < Selecteddate),

         )

Active_Visitors=

VAR MinSelectedDate =DATEADD(ALLSELECTED(Dates[Date]),-3,MONTH)

VAR MaxSelectedDate = SELECTEDVALUE(Dates[Date])

 

RETURN   

    CALCULATE([Users[Id]

        FILTER(User, User[last_login]>= MinSelectedDate && User[last_login]<=MaxSelectedDate)

         )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Emmy66 

From your initial description, you may want to show the count of Full Time Employees and Part Time Employees by measure.

I think in your fact table it should have a column like type of employee to let me distinguish full time or part time employees.

And there should be a column or multiple columns with values in Metric and details like United Kingdom/Australia... in Country.

However I couldn't find them in your data model.

I need more details about your table. Or you can share a sample with me by your Onedrive for Business.

Could tell me your calculate logic of your measure?

Does Active_Visitors calculate the count of full time employee?

 

Best Regards,

Rico Zhou

 

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