Hi All,

I'm new to power pivot. Please help on this task. I've different number of columns and also i've generated new DAX columns based on columns what i've in database.

For example:

If my columns are A_Out, A_In, B_Out, B_In, C_Out, C_In, D_Out, D_In etc., I've generated DAX columns as

([A_Out]-[A_In])/100,  ([B_Out]-[B_In])/100,  ([C_Out]-[C_In])/100

and given Calculated Column names as A, B, C.

Now i've the data in my sheet is A, B, C as show in  below content

A	B	C
20.9	43.8	55.6
23.7	21.9	43.8
50.8	78.8	56.1

I want to take dimension as A and expression as count of A  in chart or pivot table.

i'll get the result as below when i did this using qlikview. Now i want to do this using power pivot.

A CountOfA

20.9 2

23.7 5

50.8         9

- Not only this i want the data based on bu-get wise for example with A column:

For bu-get 0 to 25 the count should be 7 and 25 to 50 should be 9

I did this in qlikview please refer attached image which i did in qlikview. 

How can i do this power pivot please help me...

• Edited by Jagannalla Tuesday, June 05, 2012 9:26 AM

Hello !! Anyone can me the idea. I don't exactly what i shown in the above image. Otherwise tell me whether we can achieve this or not in different way. How can we make group get there count value?

Jagannalla,

Is this still an issue?

Thanks!