Forum Discussion
Unable to Use Measure for Filter
Yeah, that's why I am confused b/c the drop-down is not available for a Card visual, but I can get it to activate for others Visuals such as Table.
I actually found another work around (though imperfect) which is to use a relative time filter on the visual level so that only data from "1 business week" is displayed. Since our data model refreshes weekly this will work well and is currently pulling exactly as needed.
hi Anonymous ,
you need to set the DAX code in a calculated column of the table, and then drop the column in the page filter. The DAX in the calculated column will update every time the model refreshes.
Thank you very much. I will discuss with my EBI team as the way our current live data model is setup, I am unable to create calculated columns, only measures.
Thank you again.
Hi Anonymous ,
Normally you click on drop arrow to switch filter mode. If this not works, can you please share more detail information if there are any specify settings in your formula? What the nested measure formula and type that you sued in the current formula?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Yeah, that's why I am confused b/c the drop-down is not available for a Card visual, but I can get it to activate for others Visuals such as Table.
I actually found another work around (though imperfect) which is to use a relative time filter on the visual level so that only data from "1 business week" is displayed. Since our data model refreshes weekly this will work well and is currently pulling exactly as needed.