Forum Discussion

emate88's avatar
emate88
Regular Visitor
2 years ago
Solved

Power BI - tableau LODs

Hi Team!

I am trying to switch from Tabluea to PowerBI, going pretty good, but I really can't wrap my head around Tabluea LODs -> PowerBI.
I have 3 tables (visual excel screen below - 3 tables connected by id keys) and I want to show in 1 table list of my product + sales of this product + sum of market sales for each product + market Share. 

In tabluea I have to use : {Fixed [Market Name]: sum([Sales])} and this gives me for each product /row - value of respective market in Power BI - i am stuck, I was trying to play with All / ALLEXCEPT - but this doesnt seem to work (creates duplicates and shows total, and not sales per Market)

## Ok, I managed to figure out, why I have duplicates, but still can't agreegate sales on the Market Level.

 

 

 

 


Thanks,
M

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi emate88 

     

    Give this measure a try

    Market Sales = CALCULATE(SUM(Sales[Sales]),ALL(Sales),Sales[Market_id]=MAX(Sales[Market_id]))

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi emate88 

     

    Give this measure a try

    Market Sales = CALCULATE(SUM(Sales[Sales]),ALL(Sales),Sales[Market_id]=MAX(Sales[Market_id]))

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

    • emate88's avatar
      emate88
      Regular Visitor
      2 years ago

      Thanks, that will work as well. I was playing around and found at least 2 more solutions...
      Power BI is very similar to Tabluea, but LOD -kind of calcs in tabluea are much easier 😉