u/Acceptable-Sail-4575

ISSUE with measire, Need help fixing anomalie !

ISSUE with measire, Need help fixing anomalie !

i am using a matrice component to show some measures.

when i put my main measures i have the right calculation and the right %

https://preview.redd.it/dt5xr4xpwa1h1.png?width=901&format=png&auto=webp&s=fcbd04e3d08f1cbcb424fea0ea34de387ad88308

when i add the second measure, all the calculation of the first calculation become 0.0%.

https://preview.redd.it/zwmis9umwa1h1.png?width=926&format=png&auto=webp&s=36bc4db73eebc4b21a43c7830aceb410aff689e6

here is the second measure :

>%NB_REPONSES = FORMAT(DISTINCTCOUNTNOBLANK('[BASE]'[ID_REPONSE]) / CALCULATE(DISTINCTCOUNTNOBLANK('[BASE]'[ID_REPONSE]), ALLSELECTED('[BASE]')), "0.00 %" )

I think the issue is related to ALLSELECTED. When I switch it to ALL, the problem disappears, but ALLSELECTED is the correct choice because I need to calculate the percentage within the context of the filters selected by the user

reddit.com
u/Acceptable-Sail-4575 — 8 days ago