Calculate variance between two Matrix in Power Bi
I have two matrixes in power Bi user can choose a forecast from point in time and select which month to see the results. from 1st slicer they choose the first creation date (year and Month) then they choose which month to see the forecasts for in the 1st matrix same for the 2nd matrix for a different point in time so, we end up with two matrixes. how can I calculate the variance between these two matrixes? Thanks results
Printing content of web link in power bi table [ column] in one go
I have use case , A table has column mnamed LINK. it hold https link to a pdf content. there will be more rows in table with link as column. I am trying find solution to have button [ one click] does below. 1. Iterates all the links in LINK column 2. hit the link and get the PDF content one by one 3. Send the pdf to printer. How can i achieve this ?Incorrect value if interaction with filter (Date Slicer) is on
here we can see the first table that has interaction with filters on top has wrong values but the second one when i turn the interactions off has right values. Here is my measure to calculate last year value ` Last_Year_value = CALCULATE( SUM(Profit_and_Loss[Value]), DATEADD('Calendar'[Date],-12,MONTH) )` I have a relation one sided between profit_and_loss table and Calendare table here it is the relation between the two tables I tried using "REMOVEFILTERS() / ALL() / ALLEXCEPT()", but non of them worked.Matrix Visual Column Grand Totals are returning 100% instead of calculating x/y
Hello Experts, @amitchandak , Greg_Deckler Im currently showing Matrix Visual with Aging Bucktes in columns along with Outstandings and Percentages. In rows, im using Location Name. Each Bucket percentages are looking good but my column Grand Totals are showing 100% Here is my measures x/y 1) BalanceOutstanding (x)= CALCULATE( SWITCH( SELECTEDVALUE('Fact_AR_Invoice'[InvoiceStatusDisplay]), "Posted",IF(ISBLANK(SUM('Fact_AR_Invoice'[InvoicePayment])),[Invoice Values],SUM('Fact_AR_Invoice'[Balance])), "Paid",IF(SELECTEDVALUE( 'Fact_AR_Invoice'[CustomerPaymentDate])>[Selected Date],[Invoice Values], SUM('Fact_AR_Invoice'[Balance])), "New", sum('Fact_AR_Invoice'[InvoiceAmount]) ), Filter('FACT_AR_Invoice',COUNTROWS(FILTER ('Aging',[Days Overdue] >= Aging[Min] && [Days Overdue] <= Aging[Max]))>0)) 2) BalanceOutstanding_TotalbyLocation (Y) = Calculate(sumx('AR Measures',[BalanceOutstandingTest]),ALL('Aging'[Aging])) 3) % BalanceOutstanding_PastDue (X/Y) = [BalanceOutstandingTest]/[BalanceOutstanding_TotalbyLocation] I tried to adjust BalanceOutstaning_TotalbyLocation measure with ALLSELECTED and VALUES but still it is showing 100% in column grandtotals. Please any quick help will be appreciated. Thanks in Advance SOForecast/Actuals Calculations
Hi All, I have two tables Actuals, and forecasts connected through a calendar table via calendar date. I want to create a matrix where I can see one column that represents Actual/Forecast i.e. if actuals are not available then the forecast amount should be added but if actual is available then only actuals should be updated in the column. Below is the expected output. Year Qtr Actuals Forecasted Forecasted/Actuals 2022 Q1 500 300 500 2022 Q2 600 400 600 2022 Q3 0 150 150 2022 Q4 0 500 500 1100 1350 1750 I tried to create a dax but not getting the correct output Actuals/Forecast = IF ( HASONEVALUE (Date Dim'[calendar date]), IF ( [Actuals] = 0,[Forecast Amount],[Actuals] ), SUMX ('RPT Date Dim', IF ( [Actuals] = 0, [Forecast Amount],[Actuals] ) ) Please help. Greg amitchandak Pragati11
DAX Measure Error In One Row In A Matrix
Hiya I have written a measure to calculate the time saved by "NILO" compared to "Region" and all seems well in the visual except in the month of June when the calculated difference is incorrect? Here is the measure NILO Saving (Minutes) = CALCULATE ( SUM ( Tbl_NationalRawData[Minutes Taken To Respond]), Tbl_NationalRawData[Region Responded]= "REGION" ) - CALCULATE ( SUM ( Tbl_NationalRawData[Minutes Taken To Respond]), Tbl_NationalRawData[NILO Responded]= "NILO" ) The matrix uses the following data but in the row for June, the calculation is wrong. Month NILO Region July 295 102 June 105 572 May 88 190 April 169 344 March 155 104 The NILO Saving figure for June in the matrix visual returns 559 when it should be 467 (essentially the difference between the two). The visulisation rows use Month and the Value is NILO Saving (Minutes), which is the measure. All the other months return the correct difference in figures except June? I have multiple tabs using the same matrix for each region and each one has the wrong difference beingreturned for June only. Can anyone help out please? Thanks Andrew
