Forum Discussion
New table with measures values
Hi lcd,
It is the expected behavior.
Not like measures, calculate columns/tables(like your myMeasureTable) are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report(like a Slicer).
So it is not possible to create a calculate table which can change dynamically with user selections on the report. :smileyhappy:
Regards
Thanks Reid, but I need more help and so I give more information:
My 3 tables:
- EXPENSES: it's a fact table with expenses transactions.
- CALENDAR: It has all the dates I need and it's linked with EXPENSES by a date column.
- COMPANY: it's a table with companies info and it's linked with EXPENSES by companyID. In this table I have the measure:
myMeasure = TOTALYTD(sum(EXPENSES[AMOUNT]);CALENDAR[DATE])
Now, I need to have a new table with myMeasure:
myMeasureTable = SELECTCOLUMNS(COMPANY;"companyId";COMPANY[companyId];"myMeasureField";COMPANY[myMeasure])
When I use a visual with COMPANY[myMeasure] and a slicer with CALENDAR[DATE], I can control the visual with the slicer.
But when I use a visual with myMeasureTable, the slicer with CALENDAR[DATE] doesn't work.
Thanks
Hi lcd,
It is the expected behavior.
Not like measures, calculate columns/tables(like your myMeasureTable) are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report(like a Slicer).
So it is not possible to create a calculate table which can change dynamically with user selections on the report. :smileyhappy:
Regards
Thanks v-ljerr-msft, I understand. I thought this kind of tables were like measures. I will look for other solution.
Regards
Hello lcd,
I don't know if you still haven't found a solution for this topic, but here is what I've done.
1) Created a disconected table with the categories I wanted to show in my waterfall chart;
2) Created a measure using SWITCH to display the wanted value for each category;
WATERFALL VAR =
SWITCH(MAX(p_gross_margin_variances[id_var_factor]);
1;[BL05BT-GROSS MARGIN];
2;[BL03VR-PRICE VAR];
3;[BL04VR-COST VAR];
4;[BL05VR-GROSS MARGIN VAR];
5;[BL03VR-VOLUME VAR];
6;[BL03VR-MIX VAR];
7;[BL03VR-MIX AND VOL VAR];
8;[BL05AC-GROSS MARGIN];
BLANK())
3) Put the categories and values in their respective fields and voilá:The only thing is that you'll have to consider the Total bar as the Actual Value since it's not possible to change the bar name.
To do that you can use the Ultimate Waterfall from dataviz.
Hope it helped!
Regards
