Forum Discussion

mfminor's avatar
mfminor
Helper I
9 years ago
Solved

Help preventing filtering on table visualization

I have a measure want to use to divide the count of specific partnumbers vs the total number of specific units processed for the reporting period. To get the percentage I created the following measur...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    mfminor

     

    In your scenario, your total count of units processed (formula count) is associcated with each Unit Description, and the ([PN_Used Count]) is associated with each [PN_Used], you shoud have two counts group on different column, the measure should be like:

     

    PN_Used Count vs Formula Count = 
CALCULATE(AviationTable[PN_Used Count],ALLEXCEPT(AviationTable,AviationTable [PN_Used]))
/ 
CALCULATE(aviationtable[Formula Count],ALLEXCEPT(AviationTable,AviationTable[Unit Description]))

    Regards,

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Not entirely following what you are after, but it sounds like a problem that could be fixed with an ALLEXCEPT clause somewhere in your formula to remove certain column contexts from the calculation. In your case, it sounds like an ALLEXCEPT(PN_Used), so remove all context filters except PN_Used. So perhaps something like:

 

PN_Used Count vs. Formula Count = 
VAR myvar = FORMAT(DIVIDE(AviationTable[PN_Used Count], aviationtable[Formula Count],"no result"),"percent")
RETURN CALCULATE(myvar,ALLEXCEPT(AviationTable[PN_Used]))

Again, not understanding exactly what you are after but something along these lines is probably the answer.