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.
Can anyone help? I have the following code:
Solved! Go to Solution.
Hi @Anonymous ,
Try the following code:
Data = FILTER ( SUMMARIZECOLUMNS ( Invoices[Account], Invoices[ClientID], Invoices[CostCentre], Invoices[Date], Invoices[DebtorCode], Invoices[Description], Invoices[Gestation], "Fees", SUM ( Invoices[Fee] ) ), Invoices[Description] IN { "Jackets", "Tops" } && [Fees] <> 0 )
Be aware that the [Fees] is the column you are using on the SUMMARIZECOLUMNS that you created, when making tables you can reference column from that virtual table to filter out values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@Anonymous Please post the sample data and expected output, which will be helpful to suggest you an accurate solution.
Proud to be a PBI Community Champion
Output as an example would be
Account ClientID CostCentre Date DebtorCode Description Gestation Fees
123 6 23 20180303 26 Trousers 6 36
126 8 24 20180307 26 Jacket 7 0
I could filter out the second record once I have generated the table but I don't want the second record as it was return as it is zero and the only way I know it is zero from records is because when I used SUM in SUMMARIZECOLUMNS the fee for the sale and the fee for the return cancelled each other out.
For modelling I need the Fees = 0 to be filtered out during the creation of the table not by a measure afterwarrds.
Thanks in advance.
Hi @Anonymous ,
Try the following code:
Data = FILTER ( SUMMARIZECOLUMNS ( Invoices[Account], Invoices[ClientID], Invoices[CostCentre], Invoices[Date], Invoices[DebtorCode], Invoices[Description], Invoices[Gestation], "Fees", SUM ( Invoices[Fee] ) ), Invoices[Description] IN { "Jackets", "Tops" } && [Fees] <> 0 )
Be aware that the [Fees] is the column you are using on the SUMMARIZECOLUMNS that you created, when making tables you can reference column from that virtual table to filter out values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you that worked perfectly. Thank you 🙂
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |