Filter individual colums to form a dashboard

[Seiryth]

Hi All,

i'm trying to show a sales dashboard that demonstrates the gross profit per sales person. Each entry in the gross profit column has a column next to it called rating, which can comprise of two potential values: commited and coming.

I need to create a view that shows a single visual in power bi, with the commited value in one column and another in a coming column, with each row representing a sales person.

i've been wracking my brain on how to do this, as visual filters and page level filters leave me with one or the other and not both.

[BhaveshPatel · Accepted solution]

@Seiryth

Not sure is this what you would like to achieve in your final results. Please follow the screenshots.Sample TableCreate a Measure for comingCreate a measure for committedFinal Results

[ankitpatira · Accepted solution]

@Seiryth create two calculated columns one called commited and other called coming as below,

Commited = IF (tableName[rating] = "Commited", 1 , 0)

Coming = IF (tableName[rating] = "Coming", 1 , 0)

Then use clustered column or bar chart and drop two calculated columns onto Values section and you will now be abe to see sum/count of commited and coming values onto same visual.

[Seiryth]

ok so I ended up figuring this out throughout the day, this is how I ended up doing it...

I created two calculated columns as such

Commit revenue = CALCULATE(SUM('Pipe - This Month'[Product_Revenue]),'Pipe - This Month'[Rating]="Commit")
Commit cost= CALCULATE(SUM('Pipe - This Month'[Product_Cost]),'Pipe - This Month'[Rating]="Commit")

Coming revenue = CALCULATE(SUM('Pipe - This Month'[Product_Revenue]),'Pipe - This Month'[Rating]="Coming")
Coming cost= CALCULATE(SUM('Pipe - This Month'[Product_Cost]),'Pipe - This Month'[Rating]="Coming")

then i created two columns, one for commit and one for coming as such:

GrossProfit Commit= ('Pipe - This Month'[Commit Product Revenue]/1000-'Pipe - This Month'[Commit Product Cost]/1000)

GrossProfit Coming= ('Pipe - This Month'[Coming Product Revenue]/1000-'Pipe - This Month'[Coming Product Cost]/1000)

this gives me my commit and coming columns i needed 🙂 

[BhaveshPatel · Accepted solution]

@Seiryth

Not sure is this what you would like to achieve in your final results. Please follow the screenshots.Sample TableCreate a Measure for comingCreate a measure for committedFinal Results

[GilbertQ]

Just a thought would be to possibly create 2 measures, one for Commited and one for Coming?

And in doing so you could then use a visual to display them together?