Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.

 

 

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 

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    4 years ago

    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

3 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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