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

TomMartens's avatar
TomMartens
Super User
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
      Super 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