Forum Discussion

Anonymous's avatar
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"....
while
Anonymous's avatar
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's avatar
    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's avatar
      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.