The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a matrix setup and I'm using the columns to pull out my Prod, QA, and Dev into columns. This is working great. However I only need to see the rows that aren't matching. Can anyone think of a way to filter off the matching rows? I have slicer to filter Dev, QA, Prod, and one other. So we can compare up to 4 different systems at once.
Solved! Go to Solution.
@Anonymous,
Use this measure as a filter in the matrix:
Environment Match =
VAR vDev =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "Dev" )
VAR vQA =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "QA" )
VAR vProd =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "Prod" )
VAR vResult =
IF ( vDev = vQA && vDev = vProd, 0, 1 )
RETURN
vResult
Proud to be a Super User!
@Anonymous,
Use this measure as a filter in the matrix:
Environment Match =
VAR vDev =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "Dev" )
VAR vQA =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "QA" )
VAR vProd =
CALCULATE ( MAX ( Table1[Value] ), Table1[Environment] = "Prod" )
VAR vResult =
IF ( vDev = vQA && vDev = vProd, 0, 1 )
RETURN
vResult
Proud to be a Super User!
This wasn't exactly what I needed but it got me 95% there. Thank you!
I had to had vProd = vQA in the return. The issue was that when I compare all of them like that then it would return results even if I didn't have one selected in the slicer.
For example: Unit of measure | Dev Inches/Hour | Prod Inch per hour | QA Inches/Hour
Becuase it was always comparing all 3, even if I deseltected PROD from my slicer it would still show up in the matrix.
To solve this I created a measure for each Prod, Dev, QA that looks to see if it's filtered. From there I could plug those values into what you gave me and change my ouput based on it.
<Code from measure> Wouldn't let me reply if I kept it in here
So now based on what I select it changes how to calculate the output. I need to add "BU" as an option still.
I'm sure this probably isn't the cleanest way to do it but it works!
Couldn't have gotten there without your help, thank you!
Match =
VAR vDev =
CALCULATE ( MAX ( 'All'[Value] ),'All'[Source] = "Dev" )
VAR vQA =
CALCULATE ( MAX ( 'All'[Value] ), 'All'[Source] = "QA" )
VAR vProd =
CALCULATE ( MAX ( 'All'[Value] ), 'All'[Source] = "Prod" )
VAR vResult =
if([ProdFiltered] > 0 && [QAFiltered] > 0 && [DevFiltered] > 0, IF(vProd = vQA && vProd = vDev && vQA = vDev,1,0),
if([ProdFiltered] > 0 && [QAFiltered] > 0, IF(vProd = vQA,1,0),
if([ProdFiltered] > 0 && [DevFiltered] > 0, IF(vProd = vDev,1,0),
if([QAFiltered] > 0 && [DevFiltered] > 0, IF(vQA = vDev,1,0),
0)
)
)
)
RETURN
vResult
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |