cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dheeraj_ami Regular Visitor
Regular Visitor

Re: How to create level measure

 Hi   @CheenuSing I tried with the Expression, the expression excuted with out any errors and we did not met with the requirement.We are not getting values based on State Level, getting values based on city level only and the grand total value is not same, Kindly solve the issue

 

 

 

 

 

 

 

Untitled1.png

Super User
Super User

Re: How to create level measure

@dheeraj_ami

 

Can you please share the PBIX file for me to check.

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
smp0150 Frequent Visitor
Frequent Visitor

Re: How to create level measure

Hi - Was there ever any resolve for the issue? I'm trying to do a level meausre - but only have data for one table. Thanks!

Diledre Frequent Visitor
Frequent Visitor

Re: How to create level measure

Hi CheenuSing,

 

I have a Table like below 

ParentChildNo.of Prodcuts
AppleIphone100
AppleIpad200
AppleMac50
SamsungMobile2000
SamsungTVs300
SamsungRefrigirators500

 

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

 

ChildNo.of ProdcutsNo.of Products (Group By at Parent level)
Iphone100350
Ipad200350
Mac50350
Mobile20002800
TVs3002800
Refrigirators5002800

 

 

Thanks,

DILIP

Highlighted
AshokkumarM Frequent Visitor
Frequent Visitor

Re: How to create level measure

I too having the same scenario, Let me know if you have find a solution