Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I'm using PBI live connected to AZURE, so I cannot create columns, only use measures.
I have multiple tables in the cube, and the two pieces of data I want to referance are in different tables.
If table 2 is blank or is the same as the row in table 1 = "YES"
If table 2 does not match the same row on table 1 = "NO"
Table 1 | TABLE 2 | MEASURE RESULT | ||
Data 1 | Data 2 | Measure | ||
A | YES | |||
B | A | NO | ||
C | YES | |||
D | B | NO | ||
A | A | YES | ||
B | YES | |||
C | A | NO | ||
D | YES |
Thanks in advance, guys!
T
Solved! Go to Solution.
Hello @Anonymous
a measure is always to be seen in contect of the "filtering" that its be surrounded. So if you are taking about Tabl1 and Tabl2 in the context of a measure, then these 2 tables have to be in some relation. What I did is to add a index column to your tables and connected them via index. then I used a measure like this
Measure = var Data1m = FIRSTNONBLANK('Data 1'[Data 1];[Data 1])
var Data2m =FIRSTNONBLANK(Data2[Data 2];[Data 2])
Return
if ( (Data1m = Data2m)||Data2m=Blank();"yes";"no")
the output usind the index as filter is like this
it's this what you were looking after?
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello
the solution I presented is no custom column but a measure. So if you are able to create new measure, you can give it a try
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello @Anonymous
a measure is always to be seen in contect of the "filtering" that its be surrounded. So if you are taking about Tabl1 and Tabl2 in the context of a measure, then these 2 tables have to be in some relation. What I did is to add a index column to your tables and connected them via index. then I used a measure like this
Measure = var Data1m = FIRSTNONBLANK('Data 1'[Data 1];[Data 1])
var Data2m =FIRSTNONBLANK(Data2[Data 2];[Data 2])
Return
if ( (Data1m = Data2m)||Data2m=Blank();"yes";"no")
the output usind the index as filter is like this
it's this what you were looking after?
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello
the solution I presented is no custom column but a measure. So if you are able to create new measure, you can give it a try
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello @Anonymous
good luck
Jimmy
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |