Forum Discussion

zzzsharepoint's avatar
zzzsharepoint
Icon for Helper I rankHelper I
3 years ago

getting the cost based on category

I have tables like this: Project                      Category                           Cost A                        CPU                           123 A                        Networ...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Depending on the visual type your measure can be computed multiple times, each in its own filter context. In a table visual the calculation for the total is independent of the calculation for each row.

zzzsharepoint's avatar
zzzsharepoint
Icon for Helper I rankHelper I
3 years ago

Is there a way we can show the table with values and right total in a visual?any work-around?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    what is the "right" total?  What number would you expect to see? The average? The sum?

    • zzzsharepoint's avatar
      zzzsharepoint
      Icon for Helper I rankHelper I
      3 years ago

      I guess Total means Sum.. Thats what i would lIke to show

       

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        I think I already corrected that in the pbix.  Check it again please.