New Measure - Calculate percentage Filings for each CourtHouse

[pfarahani]

Hi All. 

I have a visual that contains Filings for each CourtHouse. I am trying to create a measure to add as a column that gives the percentages for each courthouse as a percentage of the total. I am using # of filings from the Filings Table and courthouse from Node levels table. 

Does anyone have the DAX to add this measure. Thanks

[pfarahani]

[v-chuncz-msft · Accepted solution]

@pfarahani 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Percent-of-Column/m-p/566652#M267371

[Greg_Deckler]

Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[edhans]

You would need to use ALL or REMOVEFILTERS to do this. Pseudocode below:

Measure =
DIVIDE(
    [# of Filings],
    ALL( 'Node Levels'[CourtHouse] ),
    0
)

[pfarahani]

Hello, 

I tried that syntax and it gives me an error. 

A table of multiple values was supplied where a single value was expected

[edhans]

You are going to need to supply some real data. We are guessing what are tables, fields, etc.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum