Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI
How to create a measure with a level (Level Metrics in microstrategy)
for eg: i need a report like SubCategory,SumOfRevenue,SumOfRevenue For Category where Category attribute should not be in report
Solved! Go to Solution.
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 @dheeraj_ami
Can you please share some data and the visuals you are expecting.
Cheers
CheenuSing
how can i create a measure with a level (Level Metrics in microstrategy)
for eg: i need a report like SubCategory,SumOfRevenue,SumOfRevenue For Category where Category attribute should not be in report
Can you share some samples of the data and the visual you want to achieve
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |