Forum Discussion

Anonymous

Not applicable

7 years ago

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"....

Zubair_Muhammad

Community Champion

7 years ago

Hi Anonymous

Check this video

https://www.youtube.com/watch?v=29frZhkwCqQ&feature=channel_video_title

"in most places, you cannot just include column references in your measures, you have to wrap them in a valid function" Rob-Collie

Anonymous
Not applicable
7 years ago
You need an aggregation on table columns
like IF(SUM('Table'[Column]) = ...
or a defined measure
like IF(SumofColumn = ....
Anonymous
Not applicable
7 years ago
Zubair_MuhammadThanks!! I understood this.
Basically I want to check when one visual selection returns status other than "Cancelled" in another visual then data card must display that "Status is in progress", otherwise blank.
So can you help me which aggregate function I can use in this scenario?
- Anonymous
  Not applicable
  7 years ago
  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")
  - Anonymous
    Not applicable
    7 years ago
    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.