Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So if you can see the screenshot below, I am able to pull the value of measure2 from a table as
Measure 2 =
Solved! Go to Solution.
Hi @Sachy123
It's impossible.You may not get the measure's value from a table's column.I would suggest you copy the formula to create the measure M2.Then create an IF condition to get the value.Here is the article about measure and column.
Measure 5 = IF(MAX(Table4[color])="M2",[M2],MAX(Table4[value2]))
Regards,
Cherie
Hi @Sachy123
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Regards,
Cherie
Hi @Sachy123
It's impossible.You may not get the measure's value from a table's column.I would suggest you copy the formula to create the measure M2.Then create an IF condition to get the value.Here is the article about measure and column.
Measure 5 = IF(MAX(Table4[color])="M2",[M2],MAX(Table4[value2]))
Regards,
Cherie
Hi @Sachy123
Do you want to count the value2 for M2?If so, you may use below measure.If it is not your case,please explain more about what you want.
Measure = CALCULATE(COUNT(Table1[value2]),Table1[color]="M2")
Regards,
Cherie
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |