Need help With Dax / Total Count By Group

[Anonymous]

Hi All, I have posted this before but haven't received any successful solutions yet.

I would be glad if someone can look into this, please. I have attached 2 datasets. (1) data to work on (2) the output.

Please find a dataset(1) here

What we like to achieve are:

1. Count of Quote_id by Group by SuperUser/Super parentID by AES OR ECOS. 

i.e for SuperUSerID 1302 / Paul Marjoram has  10 Quotes For ECOS and he is part of Chapmobile.

2.  Then Group them by total. Example In Chapmobile Group. 1 User have 10 Quotation for AES

I have tried to explain it datas  here

3. Also is it possible to show how many SuperUsers have an entry on BOTH AES and ECOS.

i.e SuperParentid 12783/ PIERS CAPLETON has an entry on BOTH AES AND ECOS

 Many thanks in advance and if you need any further info just let me know.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try Unpivot Columns in Query Editor and take a look at posts below.

• https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900
• https://community.powerbi.com/t5/Desktop/Fiiltering-table-visualisations-I-need-quot-AND-quot/m-p/602714#M286833