Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I have two measures [A] and [B].
When I put measures: [A],[B],[A]-[B] to Matrix Table, all works properly with date as Column Headers and the output changes correctly when I change the date in the slicer.
But when I want to use: Divide([A],[B],0)-1,the matrix table shows all Dates with correct output for filtered Dates and -100% for others.
Not sure why the matrix table cannot show only filtered Dates in Matrix Table for the last measure.
Please help,
G.
hi @A_a_a
dates in matrix header, slicer and measures, are they from.the same table?
Hi @FreemanZ
Measures [A] and [B] are from different tables, Date is from dim table, but all is connected by relationships.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
109 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |