topic Table columns not shown while creating New Measure in DAX Commands and Tips

Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 09:45:24 GMT

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.

Re: Table columns not shown while creating New Measure

Zubair_Muhammad — Wed, 26 Jun 2019 10:21:32 GMT

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

Re: Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 10:43:04 GMT

You need an aggregation on table columns

like IF(SUM('Table'[Column]) = ...

or a defined measure

like IF(SumofColumn = ....

Re: Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 10:45:12 GMT

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?

Re: Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 11:55:17 GMT

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

Re: Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 12:20:14 GMT

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.

Re: Table columns not shown while creating New Measure

Anonymous — Wed, 26 Jun 2019 13:19:06 GMT

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.

Re: Table columns not shown while creating New Measure

Anonymous — Thu, 27 Jun 2019 06:17:57 GMT

Anonymous Does it help?

Re: Table columns not shown while creating New Measure

Anonymous — Thu, 27 Jun 2019 06:41:47 GMT

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.