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
- NickolajJessen4 years agoSolution Sage
Allright, it's probably your measure then.
Please share the %GT measure- MIRZAMU4 years agoFrequent Visitor
I dont think it is, I just change the 'show as' value to this
- NickolajJessen4 years agoSolution Sage
Ah yes, that is the problem.
When you press "Benjamin" on your agent table, your price check visual is filtered to ONLY include data related to benjamin. Meaning you are doing 16/16 = 1 = 100%
To do 16 / 601 = 2,66%, you need to force power bi to include data from other people, even though you pressed "Benjamin" with the ALL() function