Created a Measure but Cannot Use Measure in Any Sort of Chart

[Anonymous]

Hi all,

I have a measure in my PBI report that gives me the last crew per event_idx. When I put the measure in a table it provides the correct results as shown below...

The measure for the last crew field is: 

I have related the crew actions table and jobs table: 

So... Is there anyway I can use that last crew measure as an axis in a stacked barchart to show the amount of jobs that have "failed" per crew? 

The table shows all instances of this, but I would like a way to quantify this per crew.

Any help would be greatly appreciated.

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

As @ALLUREAN  mentioned, measures could not act as X-axis.

In your case, I have created a data sample:

I'd suggest you create a new table with a column that contains all crew names, it will be used for X-axis.

New Table = VALUES('Crew Actions'[UNITNAME]) 

Then create a count measure:

Fail Count = CALCULATE(COUNTROWS('JOBS'),FILTER('JOBS',[Difference]>=30 && [Last Crew]=MAX('New Table'[UNITNAME])))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

@Anonymous  how do you calculate  - the amount of jobs that have "failed" per crew?

[Anonymous]

Essentially the pass/fail column is looking at restoration time vs estimated restoration time. If there is a difference of >=30 mins, the job failed and we need to know the count of jobs that are failing per crew.

[Anonymous]

I have a calculated column that is a pass/fail identifier based on a few equations. I want to use the last crew measure as the x axis and have the pass/fail identifier as my y axis. 

[smpa01]

@Anonymous any chance you can provide a small sample pbix?

[Anonymous]

I am connected to dataflows. Would that have any effect?

[smpa01]

@Anonymous  I guess not.

[ALLUREAN]

Hi, @Anonymous 

You can't use a measure in X-axis, but you can try replicate this measure as a calculate column if possible with your data and the use it in X-axis,