search rows of a table with more than 1 condition but not use filter dax command

[ananttripathi]

Hi,

My data looks like the following.

This is a dummy data set to explain the problem, in reality there are many objects and many properties. What I want to do is count the number of objects that contain property A(=1) and C(=1) and also the number of objects that contain property A(=1) and D(=1). Then I want to show this in a heat map visual. Like below.

 

I know the counting can be easily done by using a filter dax command, but then as soon as I use filter command it supersedes any context filter applied. Can someone please help? I prefer a heat map to show this data set but if someone has a better visualization in mind pls suggest. 

[v-yuezhe-msft]

@ananttripathi，

I am not clear about your expected result. Based on the above sample data, how will you input count numbers in the four cells of heat visual?

If you intend to use the Table Heatmap visual to show the result, I don't think it is possible, as the property values(A,B,C,D) are stored in a single column.


Regards,
Lydia

[ananttripathi · Accepted solution]

Hi Lydia,

You are right and I had to change the table format. I had to create a bit map across objects and property. Something like below. That solved my problem.

[v-yuezhe-msft]

@ananttripathi,

You have solved this issue, right? If so, please accept appropriate reply as answer to close this thread.

Regards,
Lydia