Forum Discussion
Power BI Data Labels Error
- 4 years ago
EDIT:
MIRZAMU
So, it turn out. Using ALL() makes it difficult to use the Filter pane to filter out a person, but is good at crossfiltering. Using Allselected() in stead of ALL() is bad at cross filtering but good at using the filter pane so...you can create 3 measure
Best Measure ever = IF( COUNTROWS(ALLSELECTED('Table'[Name])) = 1, [%GT Measure], //If a crossfilter selection is made [%GT Measure 2] //If no crossfilter )%GT Measure = Var _SelectedWorker = CALCULATE( SUM('Table'[PriceCheck]) ) Var _Total =CALCULATE( SUM('Table'[PriceCheck]) // ,filter(ALL('Table'[Name]), 'Table'[Name] <> "Candy") ,ALL('Table'[Name]) ) Return DIVIDE(_SelectedWorker, _Total)%GT Measure 2 = Var _SelectedWorker = CALCULATE( SUM('Table'[PriceCheck]) ) Var _Total =CALCULATE( SUM('Table'[PriceCheck]) // ,filter(ALL('Table'[Name]), 'Table'[Name] <> "Candy") ,ALLSELECTED('Table'[Name]) ) Return DIVIDE(_SelectedWorker, _Total)This set up should be good for both using the filter pane and cross filtering
Hi,
Does changing the internactions between the visuals fix your problem?
1-2. Go to format --> Edit Interactions
3. Select the visual, that you use to cross filter
4. Select Filter in stead of highligt
Hi,
No it wouldn't unfortunately as the value would still show as 100%. I need it to show the %GT Value and not 100% when I filter.
I have tried changing the interaction to filter rather than highlight but it still doesnt work