DAX Expression to remove an existing filter and apply new one
Hello, I have a Date filter in the report where I'm selecting current month. I have a requirement where I will have to calculate a certain measure with a new filter value i.e. remove the current filter and reapply a new filter. I'm restricted to using a single filter in the report which is set to current month. I'm using the following DAX expression currently where my current filter is set to "January" and I'm trying to retrieve data for "December": TechnicalEmpHeadcountProjection = CALCULATE([Technical Employee Headcount *], FILTER(ALL('Budgeting v_IncomeStatement'[PeriodFormatted].[Month]), 'Budgeting v_IncomeStatement'[PeriodFormatted].[Month]= "December")) The above DAX expression doesn't seem to work. [PeriodFormatted] is my Date column. I'm also attaching a screenshot. Kindly assist me with the DAX. Regards, RB
Pivot Table Target Measure
Hi guys... I need your help with a measure in Pivot Table with Excel. My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example below. Something like that: Criada em (Month) SemanaMes Qty Atividade DisplayTotalWeeks abr 1 446 9 abr 2 11 9 abr 3 1 9 abr 4 3 9 abr 5 1 9 mai 1 524 9 mai 2 701 9 mai 3 1 9 mai 4 2 9 Grand Total 1690 9 I have stressed ChatGPT, but it doesn't give me what I'm looking for. As an example, I have try this from GPT: TotalUniqueWeeks := COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[SemanaMes])) DisplayTotalWeeks := CALCULATE([TotalUniqueWeeks], ALL('YourTable')) It doesn't return 9, that what I was expecting. So, you are my last hope.
Hep with the formula
Anonymous Anonymous CarlossSainz Hi I have a formula below for calculating the sum of gross risk potential in the table. I want the sum calculation based on the risk name instead of summing up the entire column. I tried the below formula but it is not giving the correct value. I can give an example The total sum of gross risk potential is 100. But the gross risk potential for risk A is 20. I want to get this separate value for all the risks i have in a single column without creating multiple columns. TotalRiskPotentialPerRisk = SUMX( VALUES(Top_Risk_Controls[Riskname]), CALCULATE( SUM(Top_Risk_Controls[Gross_risk_potential]), Top_Risk_Controls[Riskname] = EARLIER(Top_Risk_Controls[Riskname]) ) ) In the above formula, im getting the same values as the gross risk potential column instead of the sum of them based on the risk name. How to get the sum of the values based on the risk name. Please note that the data source is the sharepoint list.Change and output string value in a table
Hi all, Is there away to trim or change a string from an array and only output particular terms. For example, from the table below, I only want to output the string values of 'Owners' and 'Members' and remove everything else outside of the membership column. Positional wise they will always be at the end. Current Table Group Membership Red Red 1 Owners Red Red 2 Owners Red Red Members Blue Blue Members Blue Blue 1 Owners Blue Blue 1234567 Owners Blue Access Type 12345 Owners Expectation if possible: Group Membership Red Owners Red Owners Red Members Blue Members Blue Owners Blue Owners Blue OwnersHow do I create a % formula between fields
Hi All, I have a data format like this Account Group Amount Acc1 Group1 200 Acc2 Group1 400 Acc3 Group1 100 Acc4 Group1 300 Acc1 Group2 150 Acc2 Group2 600 Acc3 Group2 200 Acc4 Group2 200 I want to calculate the share between accounts in the image below For Acc1 there is no need to do the calculation, for Acc2, Acc3... the calculation is always from Acc1. The calculation is like in the picture column % Help me for cases like thisCreating DAX Command based on Excel function. HELP!
I am trying to recreate this formula in DAX and am having trouble with the correct output. Could someone help me correct this? It is an excel IF function with OR. It involves dates so I just threw the values as "n/a" to just blanks, but I still am having issues getting the correct output... Thank you.
How do I create a measure to sum (total) up a distinct count?
Hi guys, As you can see in the picture down below I created a table with different colums: First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on Second column [Count of Versies.Id] shows the count (distinct) of the total version ID. Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X. Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V") Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID. DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id]) Fifth column [COC2-Calculated] is a measure that I created - [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount. The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533. Can anyone help me out here? Thnx!
Reduce the number of data points for X by adding range
Hi All, I basically want to plot a line chart with the below values:- Now the challenge is instead of plotting against all the values in X axis , I want to plot the X axis in a range like 0,0.1,0.2,0.3 and so on and the values for the x that lies between x = 0 to 0.1 should be plotted against all its value for Y but not as individual points . so basically X should have 0,0.1,0.2,0.3 for the below values and all the values of X against Y should be plotted in the range 0,0.1,0.2 and 0.3 instead of plotting them as inidvidual points because it will make the X plot too big so I want to divide it into subcategory.If I individually mark X against Y as per my source table then it will occupy a lot of space and will not fit the view as well Please advice if any measure or calculated field or data table can handle this line chart. My Source table is as below :- X Y 0.09424 101.2 0.09728 101.2 0.1003 101.2 0.1034 101.2 0.1064 101.2 0.1094 101.2 0.1125 101.2 0.2098 102 0.2128 102.7 0.2158 102.7 0.2189 102.7 0.2219 102.7 0.225 102.7 0.301 103.5 0.304 103.5 0.307 103.5 0.3101 103.5 Guttu
