cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power Participant

## % of total from what is visible due to a filter

Ok I made a calculation item in Tabular Editor to switch between Absolute and % view.

Now this works like a sharm and the % logic looks like this:

DIVIDE( SELECTEDMEASURE(), CALCULATE( SELECTEDMEASURE(), REMOVEFILTERS(AgeingBuckets) ) )

So on the visual we have a filter on AgeingBuckets.

Now this is a stacked column chart and this looks like:

So as you see in the last column the total is 0,33 (33%) and that is correct because the other buckets are hidden.

Now I want yet another percentage calculation that is based on the fact hat what I see is 100%.

The 0,33 should be 1. So the total that is visible should be the denominator and not all in that column.

Could I achieve this?

1 ACCEPTED SOLUTION
Power Participant

@amitchandak thought I responded already yesterday to you to ask more clarification but looks like it was not posted 😞

However I now found the solution.

This gets me what I was looking for :

DIVIDE( SELECTEDMEASURE(), CALCULATE( SELECTEDMEASURE(), ALLSELECTED(AgeingBuckets) ) )

3 REPLIES 3
Power Participant

@amitchandak thought I responded already yesterday to you to ask more clarification but looks like it was not posted 😞

However I now found the solution.

This gets me what I was looking for :

DIVIDE( SELECTEDMEASURE(), CALCULATE( SELECTEDMEASURE(), ALLSELECTED(AgeingBuckets) ) )

Power Participant

@amitchandak not sure what you mean with "total label from stacked visual" but the total that you see above the stacked chart is nowhere in my calculations. It is just in the format settings of my visual.

I also have a slicer in which can set the units to EUR, USD or quantity units.

So that is what selected value is.

These calucations are a SUM of the corresponding values field in the table.

The only thing what "breaks up" the amount is the Ageing Bucket.

But the higher (green) buckets we are not showing but this calculation is still taking those in the denominator of the divide function.

Was hoping there is a smart way to divide the ageing bucket amount thru only the total ageing bucket amounts that are visible.

Super User

@rpinxt , I you are using total label from stacked visual , I doubt that can help much. You can create a measure and used stacked line visual (use that measure as line) and then you make line width 0 from the shape