Calculate Late Arrival Time of Employee
Respected All, With referene of screenshot of my Colomns, Our Company Time is 10 AM is Checkin and 7 Pm is Check Out, While Colums [dali_time] is a actual time of Employee arrival and leave.. First of All i want to seperate the time from 1 colums to 2 colums i.e. Time in Actual and Time out Actual then after i want a new colums which show Late arrival of Employee or Leave early employee with another column late mintues or hours calculation of employee Thanks in Advance
How Filtering by multiple typeValue for the same Type
Hello, So this is my problem. I have a data set like FactData : [ID BIGINT PRIMARY KEY, CreateDate DATE, CaseCount INT, CaseValue DECIMAL(10, 2), EffectiveDate DATE, Type_A INT, Type_B INT, Type_C INT, Type_D INT, Type_E INT, Type_F INT, Type_G INT, Type_H INT, Type_I INT, Type_J INT, Type_K INT, Type_L INT, Type_M INT, Type_N INT, Type_O INT, Type_P INT, Type_Q INT, Type_R INT, Type_S INT, Type_T INT, Type_U INT, Type_V INT, Type_W INT, Type_X INT, Type_Y INT, Type_Z INT] And DimType : [ID INT PRIMARY KEY, Type CHAR(1), Value INT] I need to filter my FactData with my DimType but my fact can have multiple type and I must can select multiple types. This is my code but it not really quick, it take 15s to run across 5 million rows. Filtered Quantity = VAR _SelectedTypes = VALUES('Type'[ID]) RETURN IF( ISEMPTY(_SelectedTypes), [quantiter], CALCULATE( [quantiter], KEEPFILTERS( FILTER( 'FactData', ( FactData[TypeA] IN _SelectedTypes || FactData[TypeB] IN _SelectedTypes || FactData[TypeC] IN _SelectedTypes || FactData[TypeD] IN _SelectedTypes || FactData[TypeE] IN _SelectedTypes || FactData[TypeF] IN _SelectedTypes || FactData[TypeG] IN _SelectedTypes || FactData[TypeH] IN _SelectedTypes || FactData[TypeI] IN _SelectedTypes || FactData[TypeJ] IN _SelectedTypes || FactData[TypeK] IN _SelectedTypes || FactData[TypeL] IN _SelectedTypes || FactData[TypeM] IN _SelectedTypes || FactData[TypeN] IN _SelectedTypes || FactData[TypeO] IN _SelectedTypes || FactData[TypeP] IN _SelectedTypes || FactData[TypeQ] IN _SelectedTypes || FactData[TypeR] IN _SelectedTypes || FactData[TypeS] IN _SelectedTypes || FactData[TypeT] IN _SelectedTypes || FactData[TypeU] IN _SelectedTypes || FactData[TypeV] IN _SelectedTypes || FactData[TypeW] IN _SelectedTypes || FactData[TypeX] IN _SelectedTypes || FactData[TypeY] IN _SelectedTypes || FactData[TypeZ] IN _SelectedTypes ) ) ) ) ) So how can I improve it? I have made a pbix for example with a csv file for data. But I don't know if I hoe to share it.Manage Security Roles - Row Level Security summary figures
Hi all, My dashboard shows sales and call figures for by postcode, territory, region and national levels. I have assigned Sales reps who can only view sales and calls by their territory, whilsts Regional Sales reps can view sales and calls by their region and the split by territory whilst a select group can view all sales and calls by each region and territory. Is there a way where the Sales rep can still only view their territory but can see the total for their region and the total national figure, and the same for Regional sales reps, can they view their full region breakdown but also the national roll up? The purpose is so that each viewer can see how they are comparing to 1. National Figures and 2. Their Region. Thank you in advance!!
Use a single value to return multiple metric in bar chart?
Hello all! I have a question, I have a dataste set which looks into sum of Savings Balance for Dec'23 and for Mar'24. I have it summed up and displayed like this in bar Now I need to add a Fixed Deposit metric also that again look into sum for Dec'23 and Mar'24. I figured that having a filter that I can use to switch between Saving Account and Fixed Deposit metric for two dates would be smart, but I cant seem to form a filter that works. I made a new table called Measure Table with the below column, with these options, then a new measure, but it doesnt work. I think im missing something but not sure if theres a way to create a filter that shows value for Savings & FD. SA = IF(CONTAINS('Measure Table', 'Measure Table'[Metrics], "CASA"), [DEC'23], [Mar'24]) If any help that would be great! Thank You!
Pass selected slicer value(Text) into a measure
Hi, *I'm using Report Server Desktop "RS". I have a slicer that shows text values instead of numbers. I would like to create a measure that takes the selected "text"value(Column A) in a slicer, filters Column B based on the selected value in Column A. Then returns a "count" or "distinct count" of the filtered rows. I tried building a measure but I'm returned with a message "Cannot convert value XXXX of type Text to type Number". This seems like a simple formula but I'm not using the right syntax for DAX. Heres a table example: Column A-Slicer filters on this column Dog Cat Mouse Horse Column B PitBull Corgi Tabby Cat Jack Russell Thank you
Incorrect Measure Total on Matrix
Hello, I have a matrix in a report that contains a number of measures, unfortunately the measure total is incorrect for each one. I have been trying to find a solution but have so far had no luck, hence I am turning to the community to help. I unfortunately cant post the file as it contains business sensitive information, but will do my best to explain without it. Below is my final matrix, which has the correct monthly values but incorrect total: This is the formula used for each measure: Reforecast_Value_Ardley = CALCULATE(SUM(Anaplan_Electricity_Revenue[Value]), Anaplan_Electricity_Revenue[PPM_Name]="Ardley ERF", Anaplan_Electricity_Revenue[Version]="Budget FY24", Anaplan_Electricity_Revenue[Value_Type]="Electricity Revenue - Grid")+ ((CALCULATE(SUM(Volume_Hierachy_Final[Total_Volume]), Volume_Hierachy_Final[PPM_Name]="Ardley ERF") - CALCULATE(SUM(Anaplan_Volume_Daily[Value]), Anaplan_Volume_Daily[PPM_Name]="Ardley ERF", Anaplan_Volume_Daily[Version]="Budget FY24"))* AVERAGE(Reforecast_Power_Price[Reforecast_Price])) The formula filters tables and sums the data, then multiplies the data by a monthly price. I have been scouring the forums and it seems like the HASONEFILTER could be used to help with this issue, but I cant seem to get it to work. Let me know if any more information is required. Any help would be greatly appreciated. Thanks in advance, Josh
