Forum Discussion

radhikalakshmi's avatar
radhikalakshmi
Frequent Visitor
5 years ago
Solved

Power BI Matrix Report - Total Incorrect

Hello All,   I am trying to use a matrix visualization to view the count of issues created, updated and in backlog. While trying to retrieve backlog issues, PowerBI does and total of all rows inste...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi radhikalakshmi ,

     

    • Method1——Change the summarization type from Sum to Max like this:

     

    • Method2——Need an additional measure:
    Measure based on Backlog column = IF(HASONEVALUE('Table'[Backlog]),MAX('Table'[Backlog]),MAXX(ALL('Table'),[Backlog]))

     

    • Method3—— Create a measure instead:
    Backlog Measure instead of Backlog column = CALCULATE(SUM([Growth (Created-Closed)]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))

    Here is the final output:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi radhikalakshmi ,

 

  • Method1——Change the summarization type from Sum to Max like this:

 

  • Method2——Need an additional measure:
Measure based on Backlog column = IF(HASONEVALUE('Table'[Backlog]),MAX('Table'[Backlog]),MAXX(ALL('Table'),[Backlog]))

 

  • Method3—— Create a measure instead:
Backlog Measure instead of Backlog column = CALCULATE(SUM([Growth (Created-Closed)]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))

Here is the final output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.