Get Total of table

[Anonymous]

Hi All,

I have create a table in Power BI Desktop.

It has distinct count by category and items which have been ordered as below.

i need the ouput like below table, It simply has (SKU_counts-On_ordered)*total_SKU(distinct)*100.

And it will be dynamically based on the slicer values which i am selecting.

Output Needed
Category SKU_Count On Order         Percentage
A             100                  20                  18%         (100-20)/450*100 :- Calculation
B             150                  30                   27%
C             200                  50                   33%
Total      450                  100

Can anyone help me out....

Thanks.

[Anonymous]

Sku_count_total=calculate([Count of all order],all(table_name))

New measure=divide(([Count of all order]-[order count]),Sku_count_total)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Thanks PR20048119 ,

You are absolutely right in terms of calculation, I have got the numbers what i was looking for.

I have just a small question , what to do if i have filteres on ?

E.G in the above cae my table is filtered by the status of items which in (Continued/Discontinued).

how to resolve the same in this case?

[Anonymous · Accepted solution]

use keepfilters function or

try something like this

Sku_count_total=calculate([Count of all order],allexcept(table_name,table_name[status]))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Thanks Praveen,

This did the trick.

Appreciate your efforts.

Thanks a lot again.