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.
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())
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
How do you create a measure to get the month number for each datefield1?
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/38490
Best Regards,
Lin
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |