Individual Month Percentages

[Anonymous]

Hi All,

I am actually struggling to get the %age for individual months

My Measure looks like:

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'},MonthYear>}[XXX])

I have also tried below :

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'}>}MonthYear[XXX])

But this does not give any result.

Regards,

Saad

[YoussefBelloum]

Hi,

attach sample data and what you expect to have on the %age

[Anonymous]

HI ,

I have attached sample data in the post and also I am attaching here:

I want individual month percentages to be shown as in below table.

Sample Data

Description

Jan-2017

Feb-2017

Mar-2017

AAA

40.88%

38.52%

28.52%

BBB

18.86%

15.57%

13.57%

CCC

9.86%

9.86%

10.86%

DDD

5.24%

5.24%

8.24%

EEE

4.26%

4.26%

6.26%

FFF

4.52%

4.88%

5.88%

GGG

3.38%

3.38%

5.38%

HHH

2.45%

2.45%

3.45%

III

5.68%

5.68%

3.68%

JJJ

2.78%

2.78%

2.78%

KKK

0.57%

1.86%

1.86%

LLL

0.54%

1.54%

1.54%

MMM

0.36%

1.36%

1.36%

NNN

0.23%

1.23%

1.23%

OOO

0.14%

1.14%

1.14%

PPP

0.12%

0.12%

1.12%

QQQ

0.03%

0.03%

1.03%

RRR

0.06%

0.06%

1.06%

SSS

0.02%

0.02%

1.02%

[YoussefBelloum]

You didn't attach nothing on the document, and for the data you posted here, try to sctructure it to be able to use it

[Anonymous]

Hi,

I have attached an .xls file, same is attached here.

Regards,

Saad Zaman

[OmarBenSalem]

Can u try :

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL <ABC-={'181 and Above'},DEF={'APPROVED'},MonthYear> * <MonthYear>[XXX])

[sunny_talwar · Accepted solution]

May be this

Sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX]) /

Sum(TOTAL <MonthYear> {<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

[Anonymous]

Hi Omar,

This gives syntax error.

Regards,

Saad

[Anonymous]

Hi Sunny,

This is perfect.

Thanks a lot for your help.

Regards,

Saad Zaman

[OmarBenSalem]

That's what I wanted to do with a slight syntax error