Forum Discussion
compare measure and column values
I have a measure using a SELECTEDVALUE and a calculated column. They're both whole numbers. How do you compare the values to return all the calculated columns that equal the measure? It returns records for all the months for one year.
ReturnValue = IF(Table1[ColumnDateValue].[MonthNo] = Table1[MeasureValue],Table1[ColumnValue],BLANK())
3 Replies
v-lili6-msftCommunity Support
hi, Anonymous
It couldn't achieve that compare measure and column values, they are a different expression in logic.
For your requirement, you could create a measure based on the calculated column, then add another measure that
ReturnValue = IF(Table1[secondMeasure] = Table1[MeasureValue],1,0)
Now just drag the calculate column into visual and drag the [ReturnValue] into the visual level filter and set is "1"
If you still have the problem, Please share some sample data and expected output.
Best Regards,
Lin
- v-lili6-msft
hi, Anonymous
Sample data and expected output would help tremendously.
Column is Static, but Measrue is dynamic based on the row context, so you couldn't compare measure and columns,
please share the sample data and i will give you a workaround.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin