Forum Discussion
comparing unfiltered data to filtered data
HI I am fairly new to Power Bi so may just need to be pushed in right direction re functions. I am doing profiling of estates by the EDI strands of the people living on the estates. I want t...
Greg_Deckler
Community Champion
Community ChampionSiobhanWendy Need sample data to be specific. But to do what you want, you can do something like this:
Selected Estate =
VAR __Count = COUNTROWS('Table')
VAR __CountSelected = COUNTROWS(ALLSELECTED('Table'))
VAR __Result = DIVIDE( __Count, __CountSelected )
RETURN
__Result
Overall Population =
VAR __Count = COUNTROWS('Table')
VAR __CountAll = COUNTROWS(ALL('Table'))
VAR __Result = DIVIDE( __Count, __CountAll )
RETURN
__Result