Forum Discussion

DieLem's avatar
DieLem
Icon for Helper II rankHelper II
8 years ago
Solved

Different data levels in one row

Good Day, I have data like this:     I want to create a Matrix that shows the sum of the value. Formula:  Total Value = sum(Sheet1[Value]) My requirement is to have values from two ...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    Hi DieLem,

     

    Please refer this pbix file.
    Hope this solves your problem. Let me know if you want any explanation.

     

    Prateek raina

DieLem's avatar
DieLem
Icon for Helper II rankHelper II
8 years ago

Thanks prateekraina,

I understand the logic. 

Next up I just have to create the custom table with queries and logic on my side.

Thanks so much!

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi DieLem,

 

Glad to know that it solved your problem. 
It would be appreciated if you could hit thumbs up for my answer :)

 

Prateek Raina