Forum Discussion
Custom column (Recent Date) not working as filter in visual
Hi Anonymous
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
Measure is different with column.Column could be seen in data table.Measure could be changed with different context in visual.It could be used in visual to get dynamic value.For further,please have a look at below articles to understand it.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
You may drag it to visual level filter and set it as 1.
Regards,
Microsoft EmployeeHi Anonymous
You may create a measure with your formula instead of column.Below are some articles about column and measure for your reference.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Regards,
thank you very much..
I have two questions :
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
- v-cherch-msft
Hi Anonymous
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
Measure is different with column.Column could be seen in data table.Measure could be changed with different context in visual.It could be used in visual to get dynamic value.For further,please have a look at below articles to understand it.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
You may drag it to visual level filter and set it as 1.
Regards,