In what cases power bi don't show us percentage total in matrix?

[Anonymous]

I want to default the percentage total to 100% but power bi itself is not giving me any total. This field is frequency % of some values that may occur multiple times and in each column they are present they have the same occurance %.

[amitchandak · Accepted solution]

@Anonymous , Share your formula, you might be using row context. You can change the total using isfiltered, hasonevalue or isinscope

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Hi @amitchandak ,
I am getting no total value showed up and I am using this formula:

Problem Occurence % =
DIVIDE (
[# of Problem Occurence],
CALCULATE (
COUNTA ( FactTable[Problem] ),
ALLSELECTED ( 'FactTable' )
)
)

# of Problem Occurence =
VAR __selectedProblem = SELECTEDVALUE ( FactTable[Problem] )
RETURN
CALCULATE (
COUNTA ( FactTable[Problem] ),
ALLSELECTED ( 'FactTable' ),
FactTable[Problem] = __selectedProblem
)