Reusing measures in different tables
Hi, I’m a new BI user and this is my second post. I have 10 tables total (see the breakdown below) and have provided the tables with active relationships. My question: what do I need to so that the measures found in tables E-G can be used by other tables, specifically by tables A-D when I build my visualizations? Is it possible to extract the measures found in tables E-G to create a new table and this new will have an active relationship with tables A-D? I cannot make any of the current relationships inactive. Thank you in advance for any guidance/assistance provided. Table A – active relationship with Table E via ID Table B – active relationship with Table E via ID Table C – active relationship with Table E via ID Table D – active relationship with Table E via Name Table E – active relationship with Table C via ID and with Table G via Name (Table E has a max date formula, a conditional column, and a measure) Table F – active relationship with Table B via Name (Table F has a max date formula, a conditional column, and a measure) Table G – table has a max date formula, a conditional column, and a measure Table H – active relationship with Table G via ID Table I - active relationship with Table G via ID Table J - active relationship with Table G via ID
In power bi does any custom image visual have action field?In which we can put links there.
Hi All, According to a requirement whenever there is empty visuals (eg: no data in any visuals) then one clickable image will appear ,which will redirect to specified link. I have implemented the above using image viewer custom visual ,added a measures in the field through which the image only appears when there is no data in all the visuals. But image viewer does not have any action field in which we can add web url .I have also used image in power bi which is standard visual but there is no field section in which we can add measure, neither filter pane, but only has action field in which we can add web url. Please help how i can implement clickable image part or does any custom image visual have action field?In which we can put links there.paginated report filter by sellers
Hi ! I'm new to this and face some difficulties with the paginated report builder. I created my different tables thanks to their DAX queries exported from PBI which traduce activities of my sellers. They each have a column with the "seller_name", and I'd like to create a report which present my tables but filtered for each sellers one after another so I can send it to them personnaly. Is it possible ? I created a parameter but it seems not to filter right the tables... Can someone please help me 😞 ? Thank you !Measure to group and calculate totals
Hi everyone, I have 3 tables in my Data Model: one with the Sales value, one with the type of product, and another one with the country name. The Sales table is linked to the product table and the country table with a many to one relationship (where many is my Sales Table) I need to do a pretty complex calculation here: I would like to have, for each type of product, the total by country. Then, to have the weight of each country, i would like to divide this total by product type and by country by the total for each type of product. I don't wan't to create a new table, and I was wondering if I can create a measure, which would take into account the selected product type and country and automatically do the calculation when I analyze the data... I hope I have been clear enough 🙂 Thanks you very much to everyone, ElviCumulative Total Comparison between 2 years on Line chart
I am using a measure to calculate Cumulative Spend within a year, so 2018 should appear as a separate line and 2019 as a separate line. Cumulative Spend Previous Yr (M) = CALCULATE( SUM('Concur Report'[Expense Amount])/1000000, FILTER( ALLSELECTED('Concur Report'), 'Concur Report'[Transaction Date]<=MAX('Concur Report'[Transaction Date]) &&YEAR('Concur Report'[Transaction Date])=[Previous Year] ) ) (Another similar measure for Current year) However, please take a look at the results: I am getting this peculiar result on the 2nd image, where i want to compare cumulative 2019 vs 2018
