Matrix: Common variance column

[SivaMani]

Hello,

I'm looking for a way to create a table like below,

Name	Customer ID	Sales No	Product	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Variance
A	C1	S1	X	1091	1199	1125	1073	1036	1066	1032	1195	163
B	C2	S2	Y	1120	1016	1194	1059	1002	1002	1063	1116	53
C	C3	S3	Z	1046	1035	1115	1002	1126	1140	1036	1007	-29

I tried matrix visual,

Rows - Name CustomerID, Sales No and Product

Columns - Month

Values - Sales and Variance

Unfortunately the visual shows variance for every month.

Is there any way to attain this?

[v-chuncz-msft · Accepted solution]

@SivaMani,

You may try the measure below.

Measure =
IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )

[SivaMani]

@v-chuncz-msft,

It is not working. I'm facing the same issue like this  when I create measure using another measure,

https://community.powerbi.com/t5/Desktop/DirectQuery-Data-source-has-exceeded-the-maximum-allowed-si...