Handling very small numbers
Hi everyone! I'm having a problem with the very small numbers in my data; and the measures I created with them look like this; I'm trying to get rid of this scientific notation, and I tried some suggestions I've found here in Community, but they didn't solve my problem. The first suggestion was converting the measure to Currency format, but in that case, there are still a lot of zeros, is there any way that you can share with me to decrease the number of zeros? And I don't understand why it's between parenthesis? Couldn't remove them either. And on the other hand, there shouldn't be a dollar sign here or any sign actually I just need to see the value only, but if it's not possible to use it without the currency sign, it should be € and when I change it, it returns only 0. So I really don't know what to do with these tiny values, if you can help me with any solution, Dax formula, or any way to round it for example, I really really appreciate it. Thank you very much in advance!
Getting the sum of a column when the value is the same as previous row
Hi guys, Below you see 3 tables. In the first table there 3 columns from 3 different tables. isin column from table dim instrument, hedge from dim trade and PV_hedge is a measure from Fact trade. The total value of PV_hedge is correct namelijk 100 mil. What I want to achieve is the last table I want to see one row ISIN and the total of PV_hedge. In this case ISIN 2485 and PV_hedge 100 mil. This is the measure that I am using. I tried to use earlier but it doens not allowd. PV_Hedge = CALCULATE(SUM('Fact Trade'[amt_present_value]), 'Dim Trade_oud'[hedge_ref_trade_number] = 'Dim Trade_oud'[hedge_ref_trade_number]) Thank for your help!
Can'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 ) ))Showing Different Categories in a column chart
Hello guys, I have the data file as below : CSP CSL Co-CSL Q1 Q2 Q3 ABC CDA DAB 8 7 5 HJK LKJ GHJ 7 9 3 ASD DSA CDA 8 9 9 So i have Scores for different questions in the data and the Scores basically are calculated as average. But the challenge is that client has asked for slicers of CSP,Co-CSL and CSL where are names.So for instance if i select "CDA" in CSL it should show the score of "CDA" where he or she is mapped as CSL. And they want to compare it with his or her BU too just like in the pic below Please help me acheive this guys
