Help with measurement and calculated column.

Question

Well days, I have a problem the graph below I need to divide by months the number of partners and present them to me in a date range, the issue is that the calculated column gives me static data and not the real number of visits per month, but if you look at the table I do the same but with a measure and if it works for me,  I wanted to know why in one it works and in another not underneath is the formula and the images.  Quantity = WHERE __ID =MAX([CARDNO])RETURNCOUNTROWS(SELECTCOLUMNS(FILTER('Table visits',[CARDNO]=__ID),"__EventDate",[EVNT_DAT].[Day]))

yukik · Answer

I think you're just mixing up the concepts of row context and filter context. This article explains them well: https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

Please give me a thumbs up and accept as a solution if this helps!

syndicate_admin · Answer

I understand the difference, the issue is that when I make the calculated column it does not give me the value I want, while the measure does, but I can not use a measure as a legend of a graph, I want help to be able to make that calculated column work well

anonymous · Answer

HI&nbsp;dventura.,
When you work with the calculated column, you can't use math functions as measures to get the current value. I'd like to suggest you use the earlier function instead.
EARLIER vs EARLIEST in DAX - Excelerator BI
For the difference between measure and calculate column, you can refer to the below link:
Calculated Columns and Measures in DAX - SQLBI
Regards,
Xiaoxin Sheng

Forum Discussion

Help with measurement and calculated column.

3 Replies

Related content

Measure or Calculated Column

TMDL - calculated column

DAX Calculated Measure

Convert calculated column into measure

Write logic for Calculated Column or Measure