QS Extension table

[Anonymous]

Hi All,

How to write measures in  QS Extension table.

Dimension: [Affected Device]

Measure:

if(GetSelectedCount(Affected_Month)>0,

Round(Sum([Overall Availability%])/Count([Overall Availability%]))&''& '%',

Round(Sum({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%])/

Count({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%]))&''& '%')

i need below out put based on data.

Dimension: Valuelist('Status')

Regards,

Krishna

[OmarBenSalem]

Hi Krishna,

I did not understand one thing;

ur dimension is Status based on ur valueList or affected device?

[Anonymous]

Hi Omar,

For status i created value list.

Data: 

[Affected Device]	Availability
LAN Media	100%
WAN Media	98%
Hub	98%
Firewall	98%
Router	98%
Server	98%
IP Phone	98%
Cloud	98%
Windows Server 2012	98%
LAN	%

out put:

Regards,

Krishna.