User Profile
Notbad
Regular Visitor
Joined 4 years ago
User Widgets
Contributions
Custom formatting for table fields added by dynamic measure
Hi! I have a matrix which could display different number of fields depending on checkbox filter (I made it via dynamic measure using SWITCH() function). Is it possible to add a custom formatting to every measure separately? For examlpe I want to add a pink background to «clicks» field. Moreover (and it is even worse), all measures in table aslo have the same format (measure «Costs» on screenshot has decimal format in table, but it suppose to have a currency format in data model). Does anyone know how to fix it? Didn`t find any solution yet, probably, anyone in community knows the answer. Thanks for help!Create a measure for table with many-to-many relationship
Hi! Could you please help me with my issue? I have two tables: kyes and facts with two relationships between them. And a want to write a measure which will count distincts lead_id`s from leads table with simple condition: product_key from kyes table and facts table should be the same. But values in product_kyes fields of both tables aren't unique and thats a trouble. I tried to build a bridge table with unique product_kyes values and then use a USERELATIONSHIP function, but didn't succeed. Thanks for help!How to filter related table by measure?
Hello! I`m very-very new to Power Bi and, unfortunately, I got stuck with this issue. I have three tables (two tables with facts (costs and traffic) and one table with kyes (for filtering). I`m trying to write a measure, which will show a sum of spent money (a facts_ads_costs[adCost] field) but only if there is at least one session in table facts_GA_traffic. And this variant I wrote dies not work. amount_spent = VAR sessions = SUM(facts_GA_traffic[sessions]) RETURN CALCULATE(SUM(facts_ads_costs[adCost]), sessions > 1) Could you please help? Thanks!
