How can I convert a measure into a matching column?

[Anonymous]

I had the following function as a measure which worked successfully as a visual in grouping the failure ratio by the manufacturer name. I want to essentially recreate the visual as a full Power BI table that can be accessed by other tables.

Manufacturer Failure Ratio =

VAR CurrentValue =

SELECTEDVALUE ('Failure Table'[Manufacturer])

RETURN

CALCULATE(

DIVIDE (

COUNTA ( 'Failure Table'[Manufacturer] )

,

CALCULATE(

COUNTA ('All Devices By Region'[Mfr]),

'All Devices By Region'[Mfr]= CurrentValue

)))

I have a new table, Manufacturer Table, with one column, Manufacturer, that lists all the manufacturer names. I want to have another column based on that measure which gives the failure ratio of the corresponding manufacturer on its left, like the example below. How can I modify the measure to achieve this?

Ex.

Company A | 0.213

Company B | 0.421

[WinterMist · Accepted solution]

@Anonymous 

So maybe there is a way to do this that I am not aware of.

However, I do not believe you can create Calculated Columns based on slicer values (e.g. SELECTEDVALUE).

This is because Calculated Column data only refreshes when the dataset is reloaded.

Calculated Column data cannot be altered in between dataset refresh; for instance, when a selected slicer value is changing.  

You can definitely add the calculated column to your new table, but it will not refresh on slicer selection.

The only way to have calculation values change on the fly with selection values is by using measures.

Regards,

Nathan