New Matrix Column for Total Percentages
Hi All, I've been stuck working on creating another column in my matrix chart to capture the total percentages (shown in the red). Does anyone have any suggestions on how to solve for this or where to begin with the DAX formula? Thank you in advance for your help! Status Group 1 Group 2 Total Open/Closed % Closed 75 35 110 73.33 % Open 25 15 40 26.67% Total 100 50 150 100 %
Trying to CREATE percentage as tooltip when I Hover on bar graph
Here is the dataset: Year Type Value 2023 a 20 2023 b 50 2023 c 30 Here is the Visual: I want to see percentage when hover over a category: Here is how to make the visual: Here is the DAX I used to make the code: Measure = var a = sum('Table'[Value]) var b = if(HASONEVALUE('Table'[Type]), max('Table'[Value]) ) return b / a But the result does not show an accurate percentage when hovered: Expected result: 30/100 = 30% and not 100%TopN visual filter not showing TopN
I have a list of items (called Inc_CI_Service) and their percent of increase since last month (called _Inc Diff % PMs to SP) in a matrix. This list is filtered to only show items where there were at least 5 items during the previous month. When I try to filter the "Inc_CI_Service" on the top 5 items by "_Inc Diff % PMs to SP", it will only return the 1st item. Why and how to resolve?
Calculating percentages from measure
Hi everyone Here is my table: Number of customer (Active) is a measure: Number of Customers (Active) = CALCULATE ( DISTINCTCOUNT(au_subscriptions[au_subscriptionid]), FILTER(au_MemberStatus,au_MemberStatus[MemberStatus] = "Active"), USERELATIONSHIP( FeeDate[Date] , au_subscriptions[au_activatedon]) I am trying to create a measure to calculate the percentage? thanks Viral
Percentage of grand total per month
Hi everybody I need to calculate the percentage of a grand total in a measure. I would use this to compare the quantities of food I want to track against all the food I have in my data (even the ones I am not tracking in this visual) Food Jan 2021 Feb 2021 Pizza 10% 25% Spaghetti 25% 50% The data looks like this: Food Date Quantity Broccoli 2 jan 2021 4 Pizza 3 jan 2021 1 Bread 4 jan 2021 5 Spaghetti 5 jan 2021 2 Carrots 6 jan 2021 4 Spaghetti 7 jan 2021 3 Pizza 8 jan 2021 1 Carrots 8 feb 2021 1 Pizza 15 feb 2021 1 Spaghetti 21 feb 2021 2 ... .... ... I already tried diffrent ways of using the ALL() filter and its many varieties but I'm really not getting anywhere. Really greatfull if someone could help out! Thanks in advance! MCan't round off percentages
Hey guys, So in my power bi report, I have a measure which is the difference between two percentage measures. NPS % = Promoter % -Detractor % And I want them to calculate as 0 decimal places. I am able to show individual Promoter % and Detractor % as 74 % and 5 % but the difference is coming out incorrect. I have tried setting 0 in the measure tools for all measures but it's still showing 2 decimal values when i enable it in data label. I tried to set decimal places to 0 from the modelling view also but it still not coming correct Please need help Promoter_% = Var MaxYear=MAX('Fiscal Years'[FY]) Return IF(ISFILTERED('Fiscal Years'[FY]),DIVIDE(CALCULATE(DISTINCTCOUNT('Responses received'[Dummy ID]),'Responses received'[Q1]>=9),[Total_Responses],0), CALCULATE(DIVIDE(CALCULATE(DISTINCTCOUNT('Responses received'[Dummy ID]),'Responses received'[Q1]>=9),[Total_Responses],0),'Fiscal Years'[FY]=MaxYear)) Detractor % = var maxYear=MAX('Fiscal Years'[FY]) Return IF(ISFILTERED('Fiscal Years'[FY]),DIVIDE(CALCULATE(DISTINCTCOUNT('Responses received'[Dummy ID]),'Responses received'[Q1]>=0 && 'Responses received'[Q1]<=6),[Total_Responses],0), CALCULATE(DIVIDE(CALCULATE(DISTINCTCOUNT('Responses received'[Dummy ID]),'Responses received'[Q1]>=0 && 'Responses received'[Q1]<=6),[Total_Responses],0),'Fiscal Years'[FY]=maxYear)) NPS_% = Var maxYear=MAX('Fiscal Years'[FY]) Return IF(ISFILTERED('Fiscal Years'[FY]), IF([Total_Responses]>0,[Promoter_%]-[Detract %]+0, IF(([Promoter_%]-[Detract %])=0,"-",[Promoter_%]-[Detract %] ) ), IF([Total_Responses]>0 && ([Promoter_%]-[Detract %])=0 ,0, CALCULATE(IF( ([Promoter_%]-[Detract %])=0,"-",[Promoter_%]-[Detract %] ),'Fiscal Years'[FY]=maxYear ) ))
