Forum Discussion

kimx3263's avatar
kimx3263
New Member
8 years ago
Solved

POWER BI

Hi,   Here is what I am thinking to do, and getting stuck in Power BI.    Let's say, I have a table with 4 columns; "Year", "Gender" "Smoker Status" and "number of people"   Part 1. How many % ...
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    not sure if I understand you correctly for this reason I created a little gif that demonstrates how you can apply "additional" filter by pressing control and select from a second visual for example.

     

    I created a measure to calculate the ratio of selections to all rows

    ratio of population = 
COUNTROWS('Table1')
/
CALCULATE(
    COUNTROWS('Table1')
    ,ALL('Table1')
)

     And here is the gif

     

    Hopefully this is what you are looking for

     

    Regards,

    Tom

kimx3263's avatar
kimx3263
New Member
8 years ago

Definately Help SO MUCH!!

 

You rock!

 

Thanks!

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

Hey kimx3263,

 

please consider to mark my answer as solution this will also help others.

 

And if you really appreciate my solution you also might consider to give a Kudos to the answer ;-)

 

Cheers,

Tom