Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
2 years ago

Filter measure based on clicking visual

I have a Contracts table that includes Index, Date, Source, etc.  I have a measure to count IDs:   Total Contracts = CALCULATE(DISTINCTCOUNTNOBLANK('Contracts Signed'[Index]))   I have a bar grap...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

aashton , Are you creating a meausre like

 

divide(DISTINCTCOUNTNOBLANK('Contracts Signed'[Index]), calculate(DISTINCTCOUNTNOBLANK('Contracts Signed'[Index]), allselected()) )

  • aashton's avatar
    aashton
    Icon for Helper V rankHelper V
    2 years ago

    amitchandak   I tried this...but the bar graph by source is filtered to only display certain sources.  So using the AllSelected only gives me the total of all the sources I filtered on, and not the total from all sources overall.