Forum Discussion
Helper IIHow to show NULL on Card Visual when Filtered by a Slicer
I Shakeerm ,
you can find an example here:
https://1drv.ms/u/s!AuEtYsiOJTxVhY0TZYAmV3a14opkSQ?e=fqLYaF
I've just implemented parry2k solution and it works as expectded.
Hope it helps.
Cheers,
Marco
Shakeerm Wow, glad to hear it worked, I was not sure if you are adding this as a column. Read this post to understand the difference between Measures and Columns. It is very fundamental to work with Power BI and you get to know this.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi Shakeerm ,
I think that the reason why you are getting that error is because Power BI does not know which type of calculated column to create:
- "...." -> Text data type
- COUNTROWS -> Number data type
The error can be avoided by replacing ClosedTasks with CONVERT(ClosedTasks, STRING)
Hope it helps.
Cheers,
Marco
Helper IIHi MarcoPessina
Splendid Mate...!!! that worked..
However a quick question though, instead of usiung a New Measure i first entered this formula in a new Column & it gave me this error. What's the difference here in entering the same in a New Measure vs a New Column.
Resolver IVHi Shakeerm ,
I think that the reason why you are getting that error is because Power BI does not know which type of calculated column to create:
- "...." -> Text data type
- COUNTROWS -> Number data type
The error can be avoided by replacing ClosedTasks with CONVERT(ClosedTasks, STRING)
Hope it helps.
Cheers,
Marco