Grouped view in Visual

[Shakti_Janki]

Hi,

I'm new at this. Hopefully someone can help me.
Problem: i want to see 1 number and behind it, per status, OK or NOT OK. Can anyone tell me how to do that?
Example made in Excel: 

The check if something is OK or NOT OK is working with de DAX formula. 

This is how the data looks that i am using.

Data:

This is how the visual looks like now:

I'm hoping someone can help me :).

Grtz,
Shakti Janki

[v-yulgu-msft · Accepted solution]

Hi @Shakti_Janki,

I am unable to reproduce your issue. In my test, I created a calculated column which returned OK/Not OK based on source table. Then, I used a matrix visual to display data, add [Nummer] into Rows section, add [Status] into Columns section and add the new column into Values section.

In your scenario, it seems that the data was not grouped based on [Nummer] in visual, how did you make the DAX formula?

Regards,
Yuliana Gu

[Shakti_Janki]

Hi @v-yulgu-msft,

Thanks! I think i got it right now. The first thing was that i was not using the Matrix visual, but the Table visual.
When i changed that, i followed you advice to add [Nummer] into Rows section and added the new columns into the Values section. These changes resulted in this:

The DAX formula i used was: Impact analyse akkoord = IF(Query1[Status]="Impact Analyse geaccordeerd";IF(Query1[Functie]="FB";"OK";IF(Query1[Functie]="ICT Beheerder";"Akkoord";IF(Query1[Functie]="Changemanager";"Akkoord";"Niet akkoord")))) 

Thanks for all your help!
Also @vanessafvg

[vanessafvg]

@Shakti_Janki

it makes sent to pivot in power query in my mind. but there might be a better way to do this

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-common-query-tasks/  (look under the pivot section)

this is what i would do

1. in power query add a custom column with a value "ok"

2. pivot on the status column using the custom column as your value

what you will end up with is all your columns like your first graph except there will be 1 and 0, 1 = ok, 0 = not ok.