Forum Discussion

RedaBi's avatar
RedaBi
Frequent Visitor
2 years ago
Solved

Ratio Calculation with SUMMARIZE

I encountered an issue with calculating the ratio in RLS. When RLS is enabled, the ratio calculation does not work correctly. To work around this problem, I created a separate table to calculate the ...
  • RedaBi's avatar
    RedaBi
    2 years ago

    If it can help, I found a solution to my problem. I used the table only for the sum of sales, linking the table only with the calendar table. Then, I used the sum according to the date filter.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Most likely you wanted to use ALLSELECTED rather than ALL.

 

REMOVEFILTERS might be a gentler approach.

  • RedaBi's avatar
    RedaBi
    Frequent Visitor
    2 years ago

    Thank you for your response, Unfortunately, it doesn't work. When I drag the "Total Ventes" column along with the 'Prélevement'[Distrib] column into a table, the amount is correct, but the ratio is not. I think the issue lies in calculating the total sales of all distributors with the formula CALCULATE(SUM('Prélevement'[Facial]), ALL('Prélevement')).

    Please note that the "Prélevement" table is related to a "Calendar" table. Maybe the total needs to be filtered according to the dates specified in the calendar?