Problem with graph

[Anonymous]

Hello

I cannot create a bar graph using the following table:

K1, 12

K1, (blank)

K1, 23

L1, 24

M1, (blank)

....

The 12, 23, (blank), etc values are calculations of a MEASURE.

I drop the K1, etc column into the horizontal axis so that it should display K1, L1, M1 and the MEASURE column into the vertical axis so that it should display the SUM of the MEASURE values for K1, etc but nothing happens.

Can you advise please how to fix that?

Is it because the K1 etc column contains duplicates?

Is it because the 12, etc column is a MEASURE?

Is it because the 12, etc column contains blanks?

Thanks!

[jdbuchanan71]

@Anonymous 

If the result of the measure is a string rather than a number because you used FORMAT in the measure then it won't show in a graph.  Can you share the measure formula?

[Anonymous]

Thanks, here is the formula that I use:

MEASURE1 = IF(SELECTEDVALUE(Table1[ID])="SOME1",CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[source]=SELECTEDVALUE(Table1[System])),Table2[name]<>"",Table2[Exclusion]<>"Y"),
BLANK())

It is also formatted as WHOLE NUMBER in the table that I display this MEASURE. 

[jdbuchanan71]

If you put the category and the measure in a table visual does the measure show data?

[Anonymous]

@jdbuchanan71 

Unfortunately it does not show any data.

When I create a table visual and I drag the Category column, it displays all the unique Categories but when I add the MEASURE, the table becomes empty.

What can fix that?

Thanks!

[jdbuchanan71]

This part of your measure is evaluating as false all the time so all you are getting the BLANK() is my guess.

IF(SELECTEDVALUE(Table1[ID])="SOME1"

If you add Table1[ID] to a slicer and select "SOME1" do the values appear in the table? 

[Anonymous]

Yes, I get all the unique values of ID in the slicer.

I think the problem is it cannot aggregate results from MEASURES. I may be able to aggregate other numbers but not MEASURES.

Is there any workaround?

[jdbuchanan71]

In the slicer pick 

"SOME1"

That is the value your measure is looking for.

All measures do is aggregate date so that is not your problem.