Having a Problem with Fields in Power BI Desktop

[Anonymous]

Hello, 

I hope you can help with an issue I have in Power BI Desktop.

I created a tabular model in Visual Studio, set up all the relationsships from Dim to Fact Tables in my Star Schema (all in 1 to many relationship).

Now if I connect to my localhost Analysis Service Database, it Shows all relations and fields correctly. On the number fields I have also the Summarize Symbol for columns which I want to be summarized (amounts etc.)

The problem I have now is, when I go to the Report Tab to build my Dashboard - it does not show the Summarize Symbol in my Fact Table so I can not use them for values in my visualizations. 

In the tabular model everything might seem to be set up correctly. I also checked all columns properties and set them tho "Sum" in the Summarize Options (from default which i think should be Sum by default)

I am out of ideas what to do. 

Hope you can help me out. 

Thanks! Alex

[SpartaBI · Accepted solution]

Have you created at least 1 calculation group in your model?
In this case the implicit measures capability is forced to turn off, which is actually not a bad thing, cause in best practice you should always use explicit measures anyway and not refernce colunns as implicit measures in the report.
Check in the model propery in tabular editor what is the value for what I marked in yellow. If it's true, that will explain why. If you try to change to false and can't save, it's probably becasue you have a calculation group

[Anonymous]

Thanks for your quick reply. I checked this option and it was set to true.

And I can't set it to false because a colleague has created a calculation group for a specific reason.

So if I understood you correctly - and what seems to be the best practice - I need to create a "Sum Measure" for all the number fields that I want to use in my dashboards. Is that correct ? 
Thanks in advance! 

Alex

[SpartaBI]

Yes. 
BTW, I wouldn't use the word SUM in the measures, rather use a symbol like # or $ etc, depending on the need, but other than that, yes, all you said is correct

[Anonymous]

Thanks a lot for your help. That really get's me forward. I appreciate it 🙂