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

 

PFA screenshot.

 

Please provide some insights.

while

8 Replies

    • Anonymous's avatar
      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'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

    AnonymousNot exactly. I am not able to add screenshot for my scenario, I don't know hy. So let me explain you my complete scenario say:

    I have columns with values:

    "Item"  - Bike, Bike, car

    "Item no" - A100, A200, A300

    "Date" - null, null, 01/02/2019 .

    "Status" - In Progress, Completed, Cancelled.

     

    So now if I select Bike -

    I have to display in Card visual (Shown only if no date is there for this item, otherwise hidden):

    "A100, A200  : Date is not available for these items"

     

    In another card visual (this has to be shown only if status is not cancelled, otherwise this card should be hidden),:

    "Status is in progress or completed"

     

     

    I hope you understand my scenario. I don;t know if this kind of solution is possible or not but I am just trying to get it done.