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 am currently having an issue when adding a field to the Columns of a Matrix table.
I have simiplified the results down to see if anyone can help.
Table 1 - FactPolicyTransactions [FPT] gives me a Total of 70 Sales based on a DistinctCount of Policy.
ClassOfBusinessCode is also taken from the [FPT]
Table 2 - contains the Class of Use from the Logical.SummaryCovernetCombined table and when added to the matrix it shows as:
The correct split should be :
Commercial Office 28
Commercial Shop 42
There is a 1:* join between the tables based on PolicyTransactionKey
Any help or pointers greatly appreciated 😇
Solved! Go to Solution.
@Wardy Can you try making the cardinality to bidirectional seems like you are trying to filter table (2) with table(1) attributes which is why it is giving wrong result
Regards,
Husna
Hi @Wardy ,
How abut this?
Measure =
CALCULATE(
DISTINCTCOUNTNOBLANK('Table'[Column]),
ALL('Table')
)
If it's not work, please provide sample data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-lionel-msft thanks for taking the time to look at this. Happy to say I now have this issue resolved. 😁
@Wardy Can you try making the cardinality to bidirectional seems like you are trying to filter table (2) with table(1) attributes which is why it is giving wrong result
Regards,
Husna
Thanks @Anonymous for this solution it resolved my issue. 👏👏
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |