Forum Discussion

DieLem's avatar
DieLem
Helper 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
Helper 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
Memorable 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