topic Re: Total Not Visible in Matrix in DAX Commands and Tips

Total Not Visible in Matrix

Anonymous — Wed, 22 Sep 2021 06:43:38 GMT

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,

Issue_Tracker_Demo[Corrective Action Completed On] ) = 1970 and
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

Re: Total Not Visible in Matrix

Tanushree_Kapse — Wed, 22 Sep 2021 07:01:17 GMT

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

Re: Total Not Visible in Matrix

Anonymous — Wed, 22 Sep 2021 07:10:55 GMT

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

Re: Total Not Visible in Matrix

Anonymous — Wed, 22 Sep 2021 07:39:29 GMT

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