User Profile
sangeetaraman
Advocate I
Joined 4 years ago
User Widgets
Contributions
Re: Totals in table visual and card visual incorrect
Hello visheshjain , Thank you so much for your reply. Apologies for my delayed reply, I was preparing some sample data for your better comprehension. I'm sharing an excel file, sheets "Actual" and "Plan" are the format in which my original data is, except that its several hundred rows really. The common fields are linked in the model view on Power BI. My requirement is in the 3rd sheet. So I have appended the queries into a new query. There are two calculated measures that I have put in the excel file-which also I have calculated using measure in Power BI. Its returning correct results at a row level, though at a total/aggregated level, the result is completely wrong though I'm using sumx/averagex. I need to use these measures for further calculations/graphs etc. so they have to be measures and not calculated columns. Could you please help me? Thank you Sangeeta7.5KViews0likes0CommentsTotals in table visual and card visual incorrect
Hello Guys, I have the following card and table visuals on my report which are returning an incorrect total. Eg. Gain/Loss (in EUR) should sum up to 1.5 Million & not -163K. The formula I have used is Gain/Loss (In EUR) = CALCULATE([Bud cost(with act vol)]-SUM(ActualFY23[Actual Total Cost (EUR)])) Now I understand this is because Power BI applies the calculation on the total row, the same way as in the row level, any help/guidance on how to correct this is appreciated as I have also tried SUMX but its not working. Thanks for your help in advance. Thanks SangeetaSolved7.6KViews0likes8CommentsFreezing cell to calculate result in Power BI similar to excel
Hi Everyone, I'm trying to make matrix visual with following calculation as done in excel. Ideally I want the "B%*A Qty" column to be caluclated using a measure (by applying the "Formula" column). For every multiplication the subtotal should be multiplied with. It is easy to freeze the subtotals in the A Qty column to achive this in excel. Can anyone please guide me? Thanks in advance. Plant name B% A Qty B%*A Qty Formula Plant1 1.00% 1200 24 =1%*2400 Plant1 80.00% 200 1920 =80%*2400 Plant1 19.00% 1000 456 =19%*2400 Plant1 Total 2400.00 Plant2 45% 800.00 805.5 =45%*1790 Plant2 20.00% 950 358 =20%*1790 Plant2 35.00% 40 626.5 =35%*1790 Plant2 Total 1790.00 Rgds SangeetaSolved686Views0likes1CommentRe: Data in subscription does not match with data in the report on PBI service
Anonymous - Thank you for sharing about this feature, its interesting. However, more to my question- I am the author of the report & I have only set up the subscription for myself & my team. However, I never see the mail data matching with the data on the report service. What could be the problem? Rgds754Views0likes0CommentsData in subscription does not match with data in the report on PBI service
Hello folks, I have noticed a problem with one of my published reports. I have a subscription through which this report is sent to users daily. The subscription data & the data on the PBI report service do not match though both are referring to the same datasets with same filters applied. Has anyone come across this problem too? Rgds828Views0likes2CommentsRe: Dashboard displays different figures on subscriptions at different time with same imported data
Hello Raf_Joker - Could you resolve your issue? I see the same issue with one of my reports too. The subscription data & the data on the PBI report service do not match though both are referring to the same datasets with same filters applied. Pl let me know if you found a solution.392Views0likes0CommentsRe: Dataflow stopped saving historical data
Hi everyone, An update to my query above- My dataflow is not refreshing incrementally-each day after the refesh the data gets replaced by today's data. But in the desktop, the incremental refresh is working fine. This is strange, can anyone help me on the difference between incremental refresh in the Power BI service and Power BI desktop? What will the consequences of this be after I publish my report online? Any help is appreciated. Rgds Sangeeta818Views0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.