Forum Discussion
Table columns not shown while creating New Measure
Hello All, I am quite new to Power BI. I am facing issue that while trying to create new measure - I am not able to see columns present in the table rather it is showing me "Already created measure"....
I am not sure that i understand your goal.
but if you want something like this;
Adding Calculated Column could be a solution.
Progress = IF('Status'[StatusName] <> "Cancelled" ; "Status is in progress" ; "Status Cancelled")AnonymousThanks !! You understood it right but my requirement can be fulfilled through Measure only. So If you can help me with any kind of aggregation funtion to get this value displayed in card visual.
You can achieve that using MAX or MIN aggregate functions
ProgressMeasure = IF(MAX('Status'[StatusName]) <> "Cancelled" ; "Status is in progress" ; "Status Cancelled")If nothing selected in status filter, card visual still show "Status is in progress"
I did not understand why you have to use measure but i hope it helps you,
Feel free to ask about anything.
Anonymous Does it help?