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

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 II
Helper II

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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors