needhelp

27 Topics

Column not showing in DAX measure
Hi everyone, I’m running into a strange issue while creating a DAX measure. I have a table that includes a Year column, but when I try to use it inside a measure, the column does not appear in IntelliSense, and if I type it manually, the measure returns an error. Here is the expression I’m trying to write: DisplayItem = FORMAT(Table[Year], "0") & " — " & Table[Event However: Table[Year] doesn't show up in the field list inside the measure editor. When I type it manually, I get an error that the column cannot be found or used in this context. Other columns from the same table appear normally. I already checked the data type, refreshed the model, and validated relationships. Has anyone faced this before? Is there a specific reason why a column would not appear inside a DAX measure while it exists in the model? Any suggestions would be greatl y appreciated! ]
Solved
Nabha-Ahmed
8 months ago Place DAX Commands and Tips
1.7KViews
2likes
6Comments
dax removefilter not reconize in excel
Hi I created a dashboard in Excel with dax on my computer, it works well There is some pivot, and i have a measure like this one: mesure 1:=var nbmois =5 var CAN1p = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2];REMOVEFILTERS(Exercices[Exercices]);Exercices[Exercices]="N-1 Pr") var CAN1 = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2];REMOVEFILTERS(Exercices[Exercices]);Exercices[Exercices]="N-1") return SWITCH ( TRUE; min(Exercices[Exercices] ) = "N"; [Switch SIG Balance 2] / ( [VENTES DE MARCHANDISES + PRODUCTION 2] ); min(Exercices[Exercices] ) = "N-1"; [Switch SIG Balance 2] / ( [VENTES DE MARCHANDISES + PRODUCTION 2] ); min(Exercices[Exercices] ) = "Variation"; [Switch SIG Balance 2] /(CAN1*5/12) As you see i use REMOVEFILTERS I try to use this dashboard on a another computer, and REMOVEFILTERS isnt' reconize .... fist time i see that I try to remove and reinstall Office, same way If someone have a idea Thanks Nicolas
Solved
nicolast29
2 years ago Place DAX Commands and Tips
1.9KViews
0likes
2Comments
Measure Monthly to diary.
Hi, I have a measure [A] where it gives total monthly value. Additionally, I have a measure [B] that calculates the daily value by dividing [A] by the total number of days in the month. However, regardless of the month selected, [B] always returns the value for the last month. What I want is a new measure that provides the sum of [B] for the selected date range. Here are the different measures. A =IF ( [IsValid], CALCULATE ( SUM ( 'table'[valueA] ), table[valueB] = "C" ), BLANK () ) ) B = VAR MonthlyValue = [A] VAR SelectedMonth = SELECTEDVALUE('Calendar'[Month]) VAR SelectedYear = SELECTEDVALUE('Calendar'[Year]) VAR DaysInMonth = DAY(EOMONTH(DATE(SelectedYear, SelectedMonth, 1), 0)) RETURN IF( [IsValid], MonthlyValue / DaysInMonth, BLANK() ) Example with data. For example, if I select the date range from February 1, 2024, to April 5, 2024, I expect the result to be: If the daily value of feb is 5, march is 6 and apr is 7, the result would be 5*days in February(29)+6*days in March(31)+7*days in April(5 in that case). The result is 145+186+35=366 Any assistance would be greatly appreciated. Thank you! Any help would be good, thanks!
Solved
BMM27
2 years ago Place DAX Commands and Tips
2.2KViews
0likes
7Comments
Power BI measure
Hello Everyone, I am newbie to Power BI. I have a table with SREQ ID and Project ID. Please refer the below Image. When I apply the filter on Project ID that contains "E" or "G", it should give me the total count of SREQ IDs. Please refer below Image: Now I just wanted to create dax measure, so that it gives count of SREQ ID's as 3 in this case. Please note that I wanted to apply the filter on the visual, don't want to define it inside dax. Thank you
Solved
HPS1RT
2 years ago Place DAX Commands and Tips
1.5KViews
0likes
5Comments
RLS_DAX_ of two disconnected table using wildcard
Hi, I am facing some issue while implementing the RLS for below fact table. main_fact_table job_no year IT123 2023 IT123467 2024 IT235 2023 IT2345 2024 IT345 2023 IT334 2024 IT3647 2023 IT3654 2024 IT6584 2023 IT6574 2024 user_access user name job_no year sourav IT12 2023 jeet IT6 2023 kunal IT6 2024 sourav IT3 2024 jeet IT2 2023 kunal IT1 2024 rupam IT3 2024 rupam IT6 2023 as i mentioned there is two table. 1)main_fact_table (this is the main facr table) 2)user_access (this is the details of user who has access to the perticuler data) these two table are disconnected table hence they have no relation between them, and we are using the coloumn "job_no" (user_access) to decide the access for a perticuler user but in the "user_access" table column "job_no" dose not contain the full value we need to implement wildcard here for example in user_access one user named "sourav" has access to the row job_no in fact table whose value starts with "IT12" AND "IT3" so sourav should she all the rows in "main_fact_table" whose "job_no" starts with "IT12" AND "IT3" and corrosponding year also should take in considaration in this case sourav should see in "main_fact_table" as below shown job_no year IT123 2023 IT334 2024
Anonymous
2 years ago Place DAX Commands and Tips
730Views
0likes
2Comments
TOPN with parameters & slicers
Hello all, I have a table with weather details. Every day, for 50 years, details like max. temp & mm. rain are updated. Below you see a screenshot of an overview page, with on top the parameter (12 items) and on the right slicers for year / decade / month / date etc. I would like only the bars for the top10 results to be shown. For example the top 10 days/weeks/months/years based on total mm. rain for the past 50 years ... or the top 10 days/weeks/months/years based on the average max. temp in the past 50 years ... and so on. Besides that would it be nice of the bar of this year would have an slighty different color. Would appereciate your help / tips very much. Thkx in advance, Rud.
Solved
RGR
2 years ago Place DAX Commands and Tips
1.6KViews
0likes
6Comments
Medida cuenta identificaciones con filtros
Team buen dia, tengo una tabla que tiene las columnas identificacion, Solicitud_ID. estoy tratando de crear una medida que me traiga la cuenta del DISTINCTCOUNT(BASE_FINAL[IDENTIFICACION]) y que tenga en cuenta toda la tabla BASE_FINAL y adicinal que tenga en cuenta que la solicitud_ID sean iguales las demas filas intento con esta medida CALCULATE(DISTINCTCOUNT(BASE_FINAL[IDENTIFICACION]),REMOVEFILTERS(),BASE_FINAL[SOLICITUD_ID]=[Solicitud]) Pero me genera el error 'Se ha usado una función 'PLACEHOLDER' en una expresión True/False que se utiliza como expresión de filtro de tabla, lo que no está permitido.'
Solved
WilliamForero
2 years ago Place DAX Commands and Tips
552Views
0likes
1Comment
Visualize at which point a threshold based on a cumulative measure is exceeded
Hi, I've made a measure to calculate a cumulative percentage of column D based on column C. Output: Now we have a KPI which states that 95% of all the files need to be done within 10 days. I want to visualize in a table for each entity at which point this 95% is exceeded. For A you see in the above table this is at 10 days, for B it is at 11 days. Example of the output: A 10 B 11 Can anyone help? Thanks, Jo
Solved
Jo_Swinnen
2 years ago Place DAX Commands and Tips
675Views
0likes
2Comments
Measure revenue before a date set by a slicer
Hi, I am trying to get revenue sums displayed as to how they were before a certain date. Users should be able to use a slicer and select manually the date they want to analyze. To do so, I created a slicer with my date table and chose the option "before". I also connected the date table to my fact table. After that, I wrote the following measure: Max Test Revenue = VAR _selecteddate= MAX(Datetable[Date]) return CALCULATE('Opportunity History'[Test sum revenue], FILTER('Opportunity History',_selecteddate)) This measure stays as a blank. I also tried writing it with treatas: VAR _selecteddate= MAX(Datetable[Date]) return CALCULATE(Opportunity History'[Test sum revenue], TREATAS({_selecteddate},Datetable[Date])) When using the latter, I see absolutely no changes when selecting different dates in the slicer. Any idea how I can solve this? Thanks in advance!
Solved
Berl21
3 years ago Place DAX Commands and Tips
586Views
0likes
1Comment
Calculate total of a parameter
Good afternoon everyone I have a parameter in my report containing "Daily", "Start of the Week" and "Monthly", and in my table, for example, I filtered "start of Week", and I want to calculate based on this selected parameter, how much was the total shipping for those week start dates minus 7 days, 1 week ago. The logic would be like this: CALCULATE(Total Shipping, Parameter[StartWeek] = Parameter[StartWeek] - 7)
Solved
Edgar_massa
3 years ago Place DAX Commands and Tips
887Views
0likes
3Comments