Filter Multiple Columns values from single table

[Anonymous]

Hello All,

I have  a table where it consists of all text data type columns and their values.

I would like to filter that report as,

Table:-

Now I would like to create a table by filtering it as as,

I really didnt get any ideas about how do i can get this.

I really need some suggestions.

Thanks,

Mohan V

[MarcelBeug]

Mohan (or Bunny😞 how should the result look like?

[Anonymous]

Thanks for the reply @MarcelBeug.

I would like to show this data in a table format only.

But as i shown in second image i would like to filter the table(image 1) and show the result in table format.

the expected result is as in second image.

if you need any furthor info, please feel free to ask

[MarcelBeug]

I honestly don't see any relationship between both tables.

What exactly is the logic to transform table 1 into table 2?

[Anonymous]

Sorry for that @MarcelBeug, but still i cant explore the confidential data.

I did created a table as below.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUQKiqqoqIJmaCuGB6YwMpVidaKUkIDMFIpwCotPSYKz0dLCCZCATjIEASJWUQKR0lBJBZhcVgRWB1KeCTUa2AoRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t, D = _t, E = _t, F = _t, G = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", type text}, {"D", type text}, {"E", type text}, {"F", type text}, {"G", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"C", "D", "E", "F", "G"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Columns",{"Attribute", "Value", "C", "D", "E", "F", "G"})
in
    #"Reordered Columns"

In above table if want to filter the table by attribute,value, D,E values,

In SQL we can write something like

'

select value, D,E from Table1 where Attribute="A";

Like wise when i tried to do it as in powerbi dax
i found this https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

And when tried to write a measure or column i cant get that EVALUATE function in powerbi DAX coz it works only in excel.

here https://community.powerbi.com/t5/Desktop/EVALUATE-statement/td-p/54066  instead of evaluate we can use calculte funtion.

Well i tried to write a measure or calculated column using the above two links,

i am getting error as

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Can you please suggest me how can i write a eqivalent measure or calculated column query in dax as above sql query

Thanks 

Mohan V

[MarcelBeug]

Sorry, I still haven't the faintest idea what you are trying to achieve and DAX is not my area of expertise, so I could only offer a Power Query solution.

[Anonymous · Accepted solution]

I think i gota solution on my own.

theres something like Newtable as we write new measure or column in powerbi.

I have used that and written the below query and it given me the output the way i am expecting.

Q1 = CALCULATETABLE(SUMMARIZE('Table','Table'[A],'Table'[B],'Table'[C],'Table'[E]),FILTER('Table','Table'[A]="a"))

[MarcelBeug]

Well, I'm glad you find your own solution.

The result looks quite different than what you were asking for though.

[Anonymous]

Ya I knew that..

Actually the ans i have posted is for only single condition.:)