User Profile
brankocareer
Helper I
Joined 2 years ago
User Widgets
Contributions
Parameter issue
Hi all, In Power BI, I created a Parameter: Budget Parameter Salaries = GENERATESERIES(-1000, 1000, 1) I then placed this variable in a slicer, which allows me to input numbers manually. However, an issue arises: If I enter 1 and press Enter, it displays 1 correctly. If I enter 2 and press Enter, it displays 1 instead. The pattern is that odd numbers display correctly, while even numbers are shown as (even number - 1). I am now change the Parameter to: Budget Parameter Salaries = GENERATESERIES(-100,100, 1). Problem solved, what does this mean? But I want to keep the range from -1000 to 1000, even bigger, I’m not sure how to resolve this issue, please help me out. Thank you! BrankoRe: The order in Matrix table
Account Category Account Category Order Rollup For Forecast Sum of Amount SALARIES 1 Employer Contributions 7473333 SALARIES 1 Salaries & Wages - Overtime 28070 SALARIES 1 Salary Permanent Positions 34042888 SUPPLIES 2 Achievement Awards 252 SUPPLIES 2 Advertising 0 SUPPLIES 2 Contract Services 2728367 SUPPLIES 2 Employee Travel 334331 SUPPLIES 2 Honoraria 3000 SUPPLIES 2 Hospitality, Corporate Event & Working Session 141692 SUPPLIES 2 Insurance Expenses 40757 SUPPLIES 2 IT Services 415941 SUPPLIES 2 Legal Expenses 5139370 SUPPLIES 2 Materials & Supplies 30858 SUPPLIES 2 Miscellaneous 81186 SUPPLIES 2 MLA Expenses 51292 SUPPLIES 2 Office Equipment & IT Supplies 179006 SUPPLIES 2 Other Employee Expenses 188096 SUPPLIES 2 Other Services 299957690 SUPPLIES 2 Publications Expenses 580398 SUPPLIES 2 Rental 90817 SUPPLIES 2 Repairs & Maintenance 28669 SUPPLIES 2 Telephone and communications 126785 OTHER 3 Allowances & Benefits 199096 OTHER 3 Amortization of Tangible Capital Assets 72854 OTHER 3 Capital Asset Acquisition 0 OTHER 3 Grants 169744428 OTHER 3 Other Expenses -316072The order in Matrix table
Hi, In the matrix table , there are 2 items under "Rows" : [Rollup Account Category ] and [Rollup], my goal is: 1. The order of [Rollup Account Category] is fixed. 2. The order of [Rollup] dynamically changes based on sorting of any "Values", when I click the header of any "Value". I have created a column called : [Rollup Account Category Order], and set the "Sort by Order" of [Rollup Account Category] based on [Rollup Account Category Order], but I can not achive my goal in the report. How can I achive that? Thank you! BrankoRLS Question
Hi Power BI Guru, I am new to RLS. I created a security table contain 2 columns [Email Address] and [Brach Code], aming to create a dynamic RLS rule: the user can only see his own branch's information. Currently the branch code is uniq, and the relation is 1 to 1. The RLS rule works well at this moment. However, I want to add more person into security table, the branch code is not uniq, the relation is changed to 1 to many, then the RLS rule doesn't work. I don't kow why. And how to address the issue? Thank you in advance! BrankoRe: Circular dependency
FreemanZ Hi FreemanZ, thank you for your quick reply! Following I provide 2 tables. Could you please help? Thank you! Branko Date Pay Day 2024/04/01 0:00 2 2024/04/02 0:00 3 2024/04/03 0:00 4 2024/04/04 0:00 5 2024/04/05 0:00 6 2024/04/06 0:00 7 2024/04/07 0:00 8 2024/04/08 0:00 9 2024/04/09 0:00 10 2024/04/10 0:00 11 2024/04/11 0:00 12 2024/04/12 0:00 13 2024/04/13 0:00 14 2024/04/14 0:00 1 2024/04/15 0:00 2 2024/04/16 0:00 3 2024/04/17 0:00 4 2024/04/18 0:00 5 2024/04/19 0:00 6 2024/04/20 0:00 7 2024/04/21 0:00 8 2024/04/22 0:00 9 2024/04/23 0:00 10 2024/04/24 0:00 11 2024/04/25 0:00 12 2024/04/26 0:00 13 2024/04/27 0:00 14 2024/04/28 0:00 1 2024/04/29 0:00 2 2024/04/30 0:00 3 2024/05/01 0:00 4 2024/05/02 0:00 5 2024/05/03 0:00 6 2024/05/04 0:00 7 2024/05/05 0:00 8 2024/05/06 0:00 9 2024/05/07 0:00 10 2024/05/08 0:00 11 2024/05/09 0:00 12 2024/05/10 0:00 13 2024/05/11 0:00 14 2024/05/12 0:00 1 2024/05/13 0:00 2 2024/05/14 0:00 3 2024/05/15 0:00 4 2024/05/16 0:00 5 2024/05/17 0:00 6 2024/05/18 0:00 7 2024/05/19 0:00 8 2024/05/20 0:00 9 2024/05/21 0:00 10 2024/05/22 0:00 11 2024/05/23 0:00 12 2024/05/24 0:00 13 2024/05/25 0:00 14 2024/05/26 0:00 1 2024/05/27 0:00 2 2024/05/28 0:00 3 2024/05/29 0:00 4 2024/05/30 0:00 5 2024/05/31 0:00 6 Position ID End Date Daily Rate 50022758 2024/04/06 0:00 187.935 50023898 2024/04/13 0:00 185.2246875 50030379 2024/04/15 0:00 177.0290625 50024091 2024/04/15 0:00 168.9454688 50010717 2024/04/15 0:00 168.9454688 50052612 2024/04/15 0:00 168.9454688 50010636 2024/04/15 0:00 168.9454688 50023325 2024/04/15 0:00 168.9454688 50010591 2024/04/15 0:00 168.9454688 50080369 2024/04/16 0:00 168.9454688 50025553 2024/04/22 0:00 168.9454688 50091075 2024/04/25 0:00 166.66875 50091078 2024/04/25 0:00 166.66875 50091081 2024/04/25 0:00 165.22125 50091764 2024/05/07 0:00 165.1664063 50024060 2024/05/14 0:00 161.6592188 50019734 2024/05/17 0:00 161.6592188 50024009 2024/05/23 0:00 161.6592188 50025077 2024/05/30 0:00 161.6592188Circular dependency
Hi All, I have a calculated new column: Partial End by Day = VAR _EndDate = CALCULATE(MAX('FTE View'[End Date])) VAR _PayDaysAfterEnd = CALCULATE( COUNT('Date'[Pay Day]), 'Date'[Date] >= DATE(YEAR(_EndDate),MONTH(_EndDate),1), 'Date'[Date] <= _EndDate, 'Date'[Pay Day] <> 1 , 'Date'[Pay Day] <> 7 , 'Date'[Pay Day] <> 8 , 'Date'[Pay Day] <> 14 ) VAR _EndSalary = CALCULATE(SUM('FTE View'[Daily Rate]), 'FTE View'[Position Status]="Filled") * _PayDaysAfterEnd RETURN _EndSalary But, if want to add another new column to calaculte the value for ht ewhole month, just one row of DAX is removed, the circular depency error pops up. The new column is like: Total End by Day = VAR _EndDate = CALCULATE(MAX('FTE View'[End Date])) VAR _PayDaysAfterEnd = CALCULATE( COUNT('Date'[Pay Day]), 'Date'[Date] >= DATE(YEAR(_EndDate),MONTH(_EndDate),1), 'Date'[Pay Day] <> 1 , 'Date'[Pay Day] <> 7 , 'Date'[Pay Day] <> 8 , 'Date'[Pay Day] <> 14 ) VAR _EndSalary = CALCULATE(SUM('FTE View'[Daily Rate]), 'FTE View'[Position Status]="Filled") * _PayDaysAfterEnd RETURN _EndSalary I really don't know how to adjust my DAX to avoid the circular depency issue, please help me out. If you need more information, please let me know. Thank you in advance!!! BrankoTotal value is not right in Matrix table
Hi all, I need some hlep to calculate the total in a matrix table. When calculte each category, the condition applied is different. When calculate "SALARIES", the [Document Type] must to be "PY", for oter category, there is no such limit. I write the measure like this: APR = VAR CurrenPeriod = CALCULATE(MAX('Date'[Period]), 'Date'[Date]=TODAY()) VAR SalaryForecast = [Salary Filled Position] VAR ActualValue = IF(MAX('Rollup Master'[Rollup for Forecast Account Category])="SALARIES", CALCULATE(SUM('G/L Account'[Amount]), 'Date'[Period]=1,'G/L Account'[Document Type]="PY"), CALCULATE(SUM('G/L Account'[Amount]), 'Date'[Period]=1)) RETURN IF(CurrenPeriod>1, ActualValue, SalaryForecast) The total value 112,465 is the value without any limit. Please help how to revise the measure. Thank you in advance! Branko Rollup for Forecast Account Category Account Rollup for Corporate Report Sum of Amount Document Type SALARIES Salaries 72331 PY SALARIES Salaries 34727 SA SUPPLIES Employee Travel 3720 AC SUPPLIES Employee Travel -10112 AD SUPPLIES Employee Travel 10278 TV SUPPLIES Contract Services 472 SA SUPPLIES Materials & Supplies 100 AC SUPPLIES Materials & Supplies 680 KR SUPPLIES Other 106 KR SUPPLIES Other 163 WE
