Forum Discussion

tbrown33's avatar
tbrown33
Regular Visitor
4 years ago

Data Model measure not working

This measure was created on a data model to show the average over time to include months an entry may not be made.  This worked fine until an update was made to the model.   The new model is built in...
Need Help
tbrown33's avatar
tbrown33
Regular Visitor
4 years ago

Thanks guys.  These options have been tried, but the measures still aren't adding a 0 to the Matrix.  Power BI won't allow me to change FYMonth to a date.  Even as a decimal the 0 isn't being added.         

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, tbrown33 

Please try follow steps:

Add a new seperated table for DimCalendar[FYMonth] and establish a relationship between the new table and your original table.

New table =
DISTINCT ( DimCalendar[FYMonth] )

Then in the matrix visual, you need to replace your original field ‘DimCalendar[FYMonth]’  with the new field ‘NewTable[FYMonth]’. In this way, your original measure should work.

 

Best Regards,
Community Support Team _ Eason