Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |