Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Any ideas as to why when I filter the date and reduce on the slicer, no data will appear, but if I have all dates, and am not slicing, data will appear?
Formulas are below:
stdev_proj_invoice_card = STDEVX.P(SUMMARIZE(DimProject,DimProject[DimProj PROJECT_KEY],"Invoice Values",[Total Invoices]),[Invoice Values])
stdev_proj_invoices = CALCULATE(STDEV.P(FactInvoiceTable[TOTAL_INVOICE_PAID_AMOUNT]),ALLEXCEPT(DimProject,'DimProject'[DimProj PROJECT_KEY]))
Best.
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
More details for your scenario will be more helpful.
Do you have measures in your matrix?
If you have , please share the sample data which could reproduce the issue and the formula of the measure so that we could have a test on it.
Best Regards,
Cherry
User | Count |
---|---|
94 | |
78 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |