Forum Discussion
Helper IConvert Totals on Matrix to Average
Hi I am trying to Convert Totals on Matrix to Averages. The values is a count of specific column (Transactions). See below. How do I do this?
Hi,
Measure 2 can be simplifies to:
Measure 2 = AVERAGEX(GENERATE(VALUES('Location History'[Full Name]),VALUES('Location History'[Production Hour])),[Measure])Hope this helps.
12 Replies
Hi jbrown184 ,
Based on your description, I think your question is about the handling of hierarchies, you can use the ISFILTERED function to determine if you are affected by the hierarchy in which you are located, and thus use if judgments to differentiate between situations. You can refer to this article for better use of hierarchies:
Clever Hierarchy Handling in DAX - SQLBI
In the meantime you can also refer to this post for a reply
Solved: Changing TOTAL on a Matrix Visual from a SUM to an... - Microsoft Fabric Community
You can refer to this official document for more about ISFILTERED
ISFILTERED function (DAX) - DAX | Microsoft LearnBest regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Ashish_Mathur
Super User
Hi,
Share the download link of the PBI file.
jbrown184How do I share a download link?
- Ashish_Mathur
Upload the file to Google Drive and share the download link.
