Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
11 months ago
Solved

Relative % calculation

Hi, I have this multi measure solution that calculates % of In Stock and Out of Stock. What I am trying to do is as well to incorporate Stock Levels, since if I add them to the visuals it changes ...
Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    Hi Justas4478 ,

    i have developed a PBIX according to your ask in community, attaching Snips and PBIX. Please go through it and let us know the same you are expecting. happy to assist to you.


    Regards,
    Akhil.

Justas4478's avatar
Justas4478
Post Prodigy
11 months ago

rohit1991 So it is a bit tricky since.
What I am using as my sum is rowcount.
Since each row can have stock in (DC01 and DC06 that are values on the same column) at the same time as well there can be where only one of them or neither have any stock. So same summarized row can only be counted as in stock if sum of stock values for DC01 & DC06 is more than 0, then that summed row is counted as in stock.
Thats why my sum measure is more complex than it would be normally.

rohit1991's avatar
rohit1991
Super User
11 months ago

Hi Justas4478 

In this case, wrapping it inside a SUMX or COUNTROWS with a condition works better:

In Stock Rows =
COUNTROWS(
   FILTER(
       Stock,
       Stock[DC01] + Stock[DC06] > 0
   )
)

That way you’re checking each row first, then counting only those that qualify as “In Stock.” You can then divide that by the total row count to get the relative %.