Forum Discussion
Anonymous
6 years agoNot applicable
Static Column For Display on Card Without Slicer Interference
Hi All
I careated a column
Hours per Day = 8
And I want to show this as it is on a Card, showing the number 8.
But given that I have a slicer in the same page, it shows a number like 8616 which varies based on the date slicer that I have. How can I show only 8 and use that value from the card elsewhere?
Thanks.
3 Replies
- AnonymousNot applicable
I changed it to measure instead of column and it solved the first problem.
- v-lid-msftCommunity Support
Hi Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
- v-lid-msftCommunity Support
Hi Anonymous ,
We can use this static measure in other measure or calculate column such as following formula:
TotalHour = COUNTROWS('Table') * [Hours per Day]
Best regards,