Forum Discussion
How to create level measure
I tried using a sample data set in excel power pivot and it worked.
Create a meaure called BYCAT using the expression
BYCAT=
SUMX(
SUMMARIZE( SalesFactTable
,ProductCategory[ProductCategoryKey]
,"PYBC", Calculate(sum([Revenue],ALL(ProductCategory[ProductCategoryKey]))
)
,[PYBC]
)I am assuming you have the necessary relationship built between the various tables.
Create a cross table using this and you should be able to see the result the way you want.
The sample output in the excel power pivot model tried by me is
Try it out and if it works please accept this as a solution and also give kudos.
Hi CheenuSing,
I have a Table like below
| Parent | Child | No.of Prodcuts |
| Apple | Iphone | 100 |
| Apple | Ipad | 200 |
| Apple | Mac | 50 |
| Samsung | Mobile | 2000 |
| Samsung | TVs | 300 |
| Samsung | Refrigirators | 500 |
On the PowerBi Visual, I want to show something like below, I want to calculate the 2nd measure at the parent level even when the parent is no displayed in the visual
| Child | No.of Prodcuts | No.of Products (Group By at Parent level) |
| Iphone | 100 | 350 |
| Ipad | 200 | 350 |
| Mac | 50 | 350 |
| Mobile | 2000 | 2800 |
| TVs | 300 | 2800 |
| Refrigirators | 500 | 2800 |
Thanks,
DILIP
I too having the same scenario, Let me know if you have find a solution