Hi All,
PFB image where filter applied on Sub-category - I have measures like Sales, Discount & Profit.
I have applied %of total table calculation to Discount filed. Below image showing individual sub category wise discount % however If I select any one sub category from filter - Discount % showing as 100% instead of their actual value.
Is there any calculation to fix this?
Please advise
2 answers
Hi @Veera Bezawada, you have two options;
a. Modify the calc. to LOD expression, see code snippet below;
{FIXED [Subcategory]: SUM([Discount])}/{SUM([Discount])}b. Change the filter to TABLE calc. filter as shown below;
LOOKUP(MIN([Sub-Category]),0)
Use this in the filter instead of the Sub-category filter. I hope this helps.
