cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kazun909
Helper III
Helper III

Total Not Visible in Matrix

Hi Guys,

 

I am working on a table where I need to do a calculation based on some conditions. The calculation working fine on row level. But on the total level the result is not working fine.

kazun909_0-1632293006862.png

 

 

My conditions in the calculation are,

 

  1. Issue_Tracker_Demo[Corrective Action Completed On] ) = 1970 and
  2. Issue_Tracker_Demo[Corrective Action] not baln k and
    Also you need to take this if the Modified date is MAX at each ID level.
 Once you go thru the file you will understand the requirement properly.

 

Here is the link to Power BI file = https://drive.google.com/file/d/1nUElIxYtPrd9XihSmodNXRDN07HIau3K/view?usp=sharing

 

I would really appreciate your support on this.

Thank you.

@VahidDM @Greg_Deckler @amitchandak 

1 ACCEPTED SOLUTION
Tanushree_Kapse
Solution Supplier
Solution Supplier

Hi @kazun909 ,

 

Please try the below measure:

Total(fixed)=  SUMX(VALUES(Table[ID]), No of Correctivet Actions Pending Demo)

 

 

Mark this as a solution if I answered your question. Kudos are always appreciated.

 

Thanks

View solution in original post

3 REPLIES 3
kazun909
Helper III
Helper III

Anyways this solved my query for the time being. So Thanks for your time and support @Tanushree_Kapse 

Tanushree_Kapse
Solution Supplier
Solution Supplier

Hi @kazun909 ,

 

Please try the below measure:

Total(fixed)=  SUMX(VALUES(Table[ID]), No of Correctivet Actions Pending Demo)

 

 

Mark this as a solution if I answered your question. Kudos are always appreciated.

 

Thanks

View solution in original post

Can't we fix the total inside the same measure itself?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.