Measure

[ugogod]

I have a table as above and I put it in visualization Martrix sliced by the “Driver” as shown.

GoodsLocationDriversQty

A	TX	TOM	1
A	MS	JERY	3
A	AK	MARIO	4
A	TX	TOM	20
B	TX	TOM	2
B	AK	JERY	4
B	AK	TOM	2
C	MS	TOM	4
D	MS	JERY	1
D	IL	MARIO	2

How can I add a Measure that will form another column to increase the number of goods less than two by 4 in each location?

Example B will be 2+4 in locations AK and TX when filtered by TOM

[VahidDM · Accepted solution]

HI @ugogod 

Try this:

Measure = if(sum([Qty])<2,[Qty]+4,[Qty])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!