matrix visual

48 Topics

This post is deleted
This post is deleted.
Bertje123456
1 year ago Place DAX Commands and Tips
880Views
0likes
4Comments
Measure is Turning Blank on Table
Hi, I can calculate the diagonal values according to 2 different dates, but my aim is that create this measure for a matrix with row "customer" and one of the dates. Here is the sample data, StartYear StartMonth CalcYear CalcMonth Customer fixedfee 2023 1 2023 1 100 0.00 2023 1 2023 2 100 0.00 2023 1 2023 3 100 0.00 2023 1 2023 4 100 0.00 2023 1 2023 6 100 0.00 2023 1 2023 7 100 41.07 2023 1 2023 8 100 115.93 2023 1 2023 9 100 62.23 2023 3 2023 3 100 0.00 2023 3 2023 4 100 0.00 2023 3 2023 6 100 0.00 2023 3 2023 7 100 41.07 2023 3 2023 8 100 57.97 2023 5 2023 5 100 0.00 2023 5 2023 11 100 77.95 2023 6 2023 6 100 0.00 2023 6 2023 7 100 82.13 2023 6 2023 12 100 100.88 2023 6 2024 1 100 131.92 2023 7 2023 7 100 1,190.93 2023 7 2023 8 100 289.83 2023 7 2023 9 100 248.93 2023 7 2023 10 100 329.81 2023 7 2023 11 100 155.91 2023 7 2023 12 100 403.53 2023 7 2024 1 100 263.85 2023 8 2023 8 100 1,681.03 2023 8 2023 9 100 622.33 2023 8 2023 10 100 329.81 2023 8 2023 11 100 311.82 2023 8 2023 12 100 201.76 2023 8 2024 1 100 263.85 2023 9 2023 9 100 1,867.00 2023 9 2023 10 100 593.65 2023 9 2023 11 100 77.95 2023 9 2023 12 100 302.65 2023 9 2024 1 100 131.92 2023 10 2023 10 100 1,715.00 2023 10 2023 11 100 467.73 2023 10 2023 12 100 201.76 2023 10 2024 1 100 131.92 2023 11 2023 11 100 1,715.00 2023 11 2023 12 100 201.76 2023 11 2024 1 100 395.77 2023 12 2023 12 100 1,715.00 2023 12 2024 1 100 263.85 The measure that calculates the diagonal values below, turns blank on the matrix when "customer" is on row and "calcdate" is on column, FF_Agg = VAR startyear=SELECTEDVALUE(table[StartYear]) VAR startmonth=SELECTEDVALUE(table[StartMonth]) RETURN CALCULATE ( SUM(table[FixedFee]), FILTER(table,startyear=table[CalcYear] && startmonth=table[CalcMonth]) ) It will be dynamic table under the date filters so, I need a measure instead of calculated table, my aim matrix to reach out, CalcYear 2023 Customer CalcMonth 1 2 3 4 5 6 7 8 9 10 11 12 100 0 0 100 0 100 100 1190 1681 1867 1715 1715 1715 Thank you, Veli
vkisa
2 years ago Place DAX Commands and Tips
533Views
0likes
2Comments
Unsolvable DAX conundrum in Matrix Visual?
Hi, I have a matrix visual that is made from 2 unrelated tables and measures that executes against those 2 tables. Test Measures: Positive = IF ( SELECTEDVALUE ( 'Columns'[Value] ) = SELECTEDVALUE ( 'Rows'[Value] ), BLANK(), RANDBETWEEN ( 10, 100 ) ) Negative = IF ( SELECTEDVALUE ( 'Columns'[Value] ) = SELECTEDVALUE ( 'Rows'[Value] ), BLANK(), RANDBETWEEN ( 10, 100 ) * - 1 ) What I would like to do is to merge the 2 measures such that the positive values display above the diagonal line and the negative values are displayed below the negative values. I am having problems even approaching the issue, here is the powerbi file for reference: https://file.io/ZPVaVYkPmMrz Would really appreciate if someone could point me in the right direction.
Solved
zazaalaza
2 years ago Place DAX Commands and Tips
729Views
0likes
3Comments
Fill in missing values in a Matrix
I have a matrix pulling from a table with incomplete data. A record is created when the value changes. If the value stays the same between years, there's no record. If a given year is newer than the change year, I want the value of the column to be the last valid entry for that item. Rows is Item No Column is Year Value is a measure that's supposed to fill in Empty Values: Latest Lead Time = VAR CurrentYear = YEAR(MAX('lead time history'[Year])) RETURN IF( ISBLANK(MAX('lead time history'[Clean New Lead Time])), CALCULATE( LASTNONBLANK('lead time history'[Clean New Lead Time], 0), FILTER( ALL('lead time history'), 'lead time history'[item no] = SELECTEDVALUE('lead time history'[item no]) && 'lead time history'[Year] <= CurrentYear ) ), MAX('lead time history'[Clean New Lead Time]) ) What I have What I want: Lead Time History table:
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.1KViews
0likes
3Comments
Condtional formatting PBI matrix
Hi all, I am currently working on where I have two matrix visuals on the same page. My question is am i able to create icons for the result of matrix a- based on the result of the second matrix. e.g can i set icon to turn red in row 1- table a if result in row 1 table 2 is greater? Thank you all!
beeEc009
3 years ago Place DAX Commands and Tips
2.4KViews
0likes
4Comments
Matrix Visual - Incorrect Row header appearing under Category
I have a issue with matrix visual, where correct visual should be one as below Correct Visual Should be : Category Members EDR % By Sector AA ABC 5% XYZ 5% TTQ 5% RFP 5% A UVW 3% XYZ 3% RST 3% WWE 3% YYE 3% B YRU 2% ADC 2% FCR 2% RUP 2% POT 2% Visual I am getting(Incorrect) Category Members EDR % By Sector AA 5% ABC 5% XYZ 5% TTQ 5% RFP 5% UVW 5% XYZ 5% RST 5% WWE 5% YYE 5% YRU 5% ADC 5% FCR 5% RUP 5% POT 5% A 3% ABC 3% XYZ 3% TTQ 3% RFP 3% UVW 3% XYZ 3% RST 3% WWE 3% YYE 3% YRU 3% ADC 3% FCR 3% RUP 3% POT 3% I am using a Dax Measure to get the EDR % of Sector : EDR % of IDR average per Category = CALCULATE( DIVIDE([EDR Complaint], [IDR Complaint]), ALL('Member'[Members]) ) I noticed, if I use the Category from the members Table or calculated column(ERD % od Sector) from the Category Table I get the desired result. What I want to know if how can I achieve this with the measure. Please note: Members and Category are two different Dimension Table joined on Category relationship
Solved
rksharma86
3 years ago Place DAX Commands and Tips
610Views
0likes
2Comments
Sum visible rows in matrix visual
Hi, I have a matrix table, with multiple rows and values. I wanted to count number of products but the measure I wrote is not summing in the table nor in card visual. Rows are coming from 6 different tables. Count products = COUNTX(Metrics,[Request Quantity]) Some of the products repeat within the country and customer, but I want to count visible number of products. Also I tried to calculate the average of the Days past request date but it gives me very high number, so I suppose it takes data from the whole table and I wanted to have it only for the data from the table. Days past request date = DATEDIFF('Time - Requested By'[Requested By Date],TODAY(),DAY) Avg = AVERAGEA('Time - Requested By'[Days past request date]) I would appreciate any help.
Solved
Maieev
3 years ago Place DAX Commands and Tips
4.2KViews
0likes
15Comments
Measure based on filter which overrules row context matrix
Hi, Is there a way to create a measure based on a slicer selection which overrules the row context in a matrix? So I have the following slicer, I created a measure which is based on country level. When I select a country it needs to show de local ledger (this is a different colum). When nothing is selected it needs to show the currency EURO which is a different column in my fact table. I created the next measure: if(DISTINCTCOUNTNOBLANK('DM_Table'[LedgerCurrencyCode])>1, SUM(FACTS[CorporateAmount]),if(SELECTEDVALUE(SelectCurrency[SelectCurrency]) = "Euro", SUM(FACTS[CorporateAmount]), SUM(FACTS[LedgerAmount]))) The problem is now that in my matrix country level is used as a row, this has as an effect that my measure calculates the amount on local ledger level, but when nothing is selected in my slicer I need the measure to calculate NOT the local ledger. Eventually when 1 country is selected I want to see the local ledger. amitchandak
Solved
J4ns3n
3 years ago Place DAX Commands and Tips
868Views
0likes
3Comments
Matrix Visual - possible to add 2 different Dimension into columns
Hello, I try the following with the matrix visual: I want to visualize the amount of different products by month and by distribution group in one matrix Amount Jan Feb Mar EMAIL PHONE SHOP Produkt 1 100 300 400 100 700 Produkt 2 200 300 50 50 400 Produkt 3 500 500 100 100 300 ... ... It is a star schema where the Produkts are in the Produkt_Dimension, the months belong to the Calendar_DIMENSION and the Distribution Channels belong to the DISTRIBUTION_DIMENSION. The Amount is in the facts. I don't find a way to include the second grouping (distribution Channel). Is this possible with the matrix visual? best regards Marco
MHac
3 years ago Place DAX Commands and Tips
874Views
0likes
3Comments
I want to compare data with a Hierarchy that only exist on one part of the data
Hello all, I hope some one can help me with my problem. I use two values BGR € and Voorspelling €. The voorspelling € hierarchy in on a deeper level than the BGR €. The voorspelling € has three levels: - kostenplaats - F code - employee number The BGR € had two levels: - kostenplaats - F code I know when I drill to the employee number, that the BGR € value of the F-code will show per employee-code. My question is: When I drill down to the employee number, it is possible to only show the Voorspelling € on the employee-codes and BGR € on the F503 level as a total. Like this: Thank you all for ready and trying to help! Your sincerely, Jos
Solved
JosFry
3 years ago Place DAX Commands and Tips
909Views
0likes
2Comments