Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables - Activity and BusinessCase
The tables are currently linked (Cardinality Many to 1) Cross filter direction Both
I have a formula that calculates
DIVIDE (CALCULATE (
COUNT(Activity[id]),
ALL(BusinessCase[Status], L0_Raynet_BusinessCase[Group])),
COUNT(BusinessCase[id])
,
0
)
The formula works for me. At the same time I have filters from BusinessCase (Type of service, Status, Owner of businessCase) in the desktop version. All filters work for me (Individual activities are linked and assigned to the groups I filter). The problem occurs when I publish the version to the online environment. For example, the moment I filter Type of service, I get a count of 0 activities (all are blank). When publishing PowerBi, is there any transformation taking place where the connection between the tables is modified?
Hi @PavelS ,
”When publishing PowerBi, is there any transformation taking place where the connection between the tables is modified?“
I don't think there is such a design in Power BI.
Can you show me a screenshot of your model view (the page with the table relationships), and please be careful to hide the key sensitive information.
Best Regards,
Community Support Team _ Caitlyn
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
7 | |
3 | |
2 |