Forum Discussion

pakovic's avatar
pakovic
Icon for Helper I rankHelper I
4 years ago
Solved

Colums Calculate

Hi, I have this table in powerbi desktop and I would like to be able to display the data like this.
I have tried to use the filter function, but I get an error. is it possible to represent the table in powerbi in this way?

Attached pbix file

https://drive.google.com/file/d/1LlMuKwrs2JKNo0c0V4IfQtzKLn9pxEM5/view?usp=sharing

 

 

Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    pakovic YOu should create a Measure like below:

    Measure 2 = CALCULATE(SUM('Table'[Amount Cost]),ALLSELECTED('Table'[Type]))
     

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    4 years ago

    pakovic YOu should create a Measure like below:

    Measure 2 = CALCULATE(SUM('Table'[Amount Cost]),ALLSELECTED('Table'[Type]))
     
    • pakovic's avatar
      pakovic
      Icon for Helper I rankHelper I
      4 years ago

      Ok, you've given me a hint... the correct function maybe would be:

      Measure 2 = CALCULATE([Amount Cost];ALLSELECTED(Sales[Product]))

      Thank you very much!!!