Measure showing correct value when displayed in card but not as a title of a graph

[Anonymous]

Hi all,

Having quite a confusing moment with Power BI objects. I create a measure as follows

• count = CALCULATE(count('Table1'[column1])) 

This measure calculates correctly and is responsive to other filters/slicers when placed in a card. However, when I tried to use it as a title of a graph, suddenly it became non-responsive to filters or other graphs. Any thoughts on this?

[v-janeyg-msft]

Hi, @Anonymous Any updates?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.

Best Regards,

Community Support Team _ Janey

[v-janeyg-msft]

Hi, @Anonymous 

According to the sample file you provided, I didn't see any problems, and the slicer can also control its changes. Do you still need help? What kind of result do you want?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[Ashish_Mathur]

Hi,

I cannot say why the measure is not working in the title of your graph.  As an observation, you may simplify your measure to:

Count = Count('Table1'[column1])

Hope this helps. 

[Anonymous]

Hi Ashish,

Thank you for your response! I tried the code and it stil did not work. Actually the initial measure works only on a graph but did not work when i filtered data using the same graph. Is this a bug?

[Ashish_Mathur]

You are welcome.  My proposed amended measure was not intended to solve your question.  I may need to see your file.  Share the download link and show the problem very clearly.

[Anonymous]

Hi Ashish,

Here's the link to download:

https://drive.google.com/file/d/1_QIA4q_NEFua9qesCqScDYMyfFMbBXwp/view?usp=sharing 

Thanks for your help!

[Ashish_Mathur]

Hi,

Does this measure work?

Measure var1 title = concatenate("var 1 count = ", format(DISTINCTCOUNT('Table'[var1]), "General Number"))

[Anonymous]

Hi Ashish,

Distinctcount does not work either

[Ashish_Mathur]

Then i really do not know what result you want to see there.