Total Not Visible in Matrix

[Anonymous]

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.

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 

[Anonymous]

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

[Tanushree_Kapse · Accepted solution]

Hi @Anonymous ,

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

[Anonymous]

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