Forum Discussion
Using a Measure (that results in a text string) in a Filter expression
Hi All, I am using a measure that results in a text string to filter values in a column. This is my DAX code, I am using the measure [Selected Report Period 1] which results in a text string ...
Anonymous Since you want the report period to be the slicer, you don't need to explicitly specify it in the measure. So do you have a flag or column to indicate gross revenue 1 and 2?
If yes, your two measures will be like
gross_rev_1 := calculate (gross revenue), filter ([revenue_type] = 1)
, and the other is -
gross_rev_2 := calculate (gross revenue), filter ([revenue_type] = 2)
The third measure will be like
variance := gross_rev_1 - gross_rev_2
Hello Anonymous,
If I hardcode the Report Type filter, the filtering will not be dynamic.
There is actually more than two report periods and I want the user to choose only 2 report periods at a time, hence the selection based on the slicer.
Thank you again for taking time to understand and respond. Really appreciate it!
If I hardcode the Report Type filter, the filtering will not be dynamic.
There is actually more than two report periods and I want the user to choose only 2 report periods at a time, hence the selection based on the slicer.
Thank you again for taking time to understand and respond. Really appreciate it!
Hi Anonymous,
did you get a chance to solve this problem? I'm facing the same problem and i'd like to know how did you get though this