
▲ 0 r/PowerBI
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 %
when i add the second measure, all the calculation of the first calculation become 0.0%.
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
u/Acceptable-Sail-4575 — 8 days ago