Forum Discussion
Visual Showing a Single Calculated Figure
Hi, I have two counted values that I get from two different tables. I want to show the net figure (A total count - B total count) as a single figure in a visual. Not refering to two columns whic...
Hi,
Create a single column Dim Table. This column should be the connecting column in both tables. Create a relationship (Many to One and Single) from the two tables to this third table. To your visual, drag the field from the Dim table. Your new measure should be
Measure = [Measure1]-[Measure2]
Hope this helps.
Thanks Ashish
Added more detail to the orignial post. dont want to add a table. Looking for a visual which will show the net.
The best and perhaps the only way is to add a Calendar Table.