Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
OKgo's avatar
OKgo
Icon for Helper IV rankHelper IV
8 years ago

Great post. It give insight into why PBI is the way it is. My attempt to apply the knowledge above is failing. This matrix has muliple at a page level so the HASONEFILTER is not working out? The HASONEVALUE is not working out for me either.


Here is the measure. Edit tips appreaciated. (Credit to Ashish_Mathur)

Forecast = if(MIN('Calendar'[Date])<[First month in which data is available],BLANK(),if(EOMONTH(MAX(Workfront[Due On]),0)>=EOMONTH(MAX('Calendar'[Date]),0),
    CALCULATE([3 month av],DATESBETWEEN('Calendar'[Date],[Month till where data is available],[Month till where data is available])),BLANK()))

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    What result are you looking for?  What is your data?  Explain.

    • OKgo's avatar
      OKgo
      Icon for Helper IV rankHelper IV
      8 years ago
      I'd like those 86 values to be 82.
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

        I really do not know how you arrive at 82.  It is defenitely not a summation of the numbers in the column above.  Put in some more effort and explain your data/question.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

       

      totals wrongly showing in matrix visual

      Can you just help me to create the measure for ''average of Totals''.Row headers are place name.Thanks