cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SivaMani Senior Member
Senior Member

Matrix: Common variance column

Hello,

 

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

NameCustomer IDSales NoProductJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Variance
AC1S1X10911199112510731036106610321195163
BC2S2Y1120101611941059100210021063111653
CC3S3Z10461035111510021126114010361007

-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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Matrix: Common variance column

@SivaMani,

 

You may try the measure below.

Measure =
IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Matrix: Common variance column

@SivaMani,

 

You may try the measure below.

Measure =
IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SivaMani Senior Member
Senior Member

Re: Matrix: Common variance column

@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...