topic Re: build a new visual based on measure in DAX Commands and Tips

build a new visual based on measure

Anonymous — Thu, 19 Aug 2021 09:51:59 GMT

I am pretty new to power Bi and struggling with a report bild.

we are working with our client on building a report. and we have created a table visual which displays data in below format

product	planner (group by)	Stock coverage(Measure)
Prod A	first	Understock
Prod B	first	Understock
Prod C	first	Optimal stock
Prod D	first	Optimal stock
Prod E	other	Overstock

Now product column is column coming from product table, and planner(group by) we have a created a group based on the planner in the same table.. We have then created a measure (stock coverage) based on the stock available to see if it is understock or overstock.

Now user wants to see for the planner how many products are overstock and understock etc. output like below

Planner	Understock	Optimal Stock	Overstock
First	2	2	0
Other	0	0	1

But we cannot use a measure in a column matrix. and not sure how to get the data in required format. Any leads.

Re: build a new visual based on measure

APavlovs — Thu, 19 Aug 2021 09:58:55 GMT

Hi Anonymous ,

Since you can use columns in the matrix, i would suggest you to create a new column based on the measure.

Re: build a new visual based on measure

Anonymous — Thu, 19 Aug 2021 10:36:42 GMT

No other way of doing it? Since user had already created the measure to calculate the stock coverage (it is little complex). i was thinking to find a way to use the measure itself and try to convert the measure to calculated columns. Will give a try by converting the measures into the calculated columns and see if it works out

Re: build a new visual based on measure

APavlovs — Thu, 19 Aug 2021 10:44:57 GMT

Anonymous you can simply reference the measure in the new column