Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure Not Working With Relationship?

Hi,   I have two tables.   First is the fact table with my transactions, in which I have the Customer Name and order intake. Second is the dim table with Customer Name and Customer Segment, Cust...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I am assuming you have created a measure slicer. Remember in Time intelligence, if date is not selected on-page, the end date of ytd, mtd,qtd will end date of the calendar . So that can be an issue.

 

Slicer -https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

Power BI — YTD Questions — Time Intelligence 1–5
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD Questions — Time Intelligence 2–5
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD Questions — Time Intelligence 3–5
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

 

thank you for your reply. Yes, I do have a measure slicer in which users select a particular month and year. However, I still don't understand why my measure is not working.

 

I noticed that when I added a calculated column (lookup with customer name to get the customer segment) to my fact table, all visuals behave as expected... but why it is not working without these calculated columns, just based on the relationship?