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 would like to present a graph that shows the cumulative number of booster vaccinations required by month. created a 'dummy' model containing the scenario. Please see model in link below. I seem to be getting some spurious data for months where I am expecting no data.
Solved! Go to Solution.
Hi @sperry ,
Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.
Note: The part with red font is updated one...
Total Cumulative Boosters Required Maori =
IF (
ISBLANK ( [Total Cumulative Eligible Booster Māori] )
|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),
BLANK (),
( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )
)
|
Best Regards
Your data has blank "Eligible Booster Date" fields.
You are absolutely right - I use the data for several reasons so some rows are validly blank for the "Eligible Booster Date" fields. Not sure how this helps me. If I filter out the blank dates then incorrect values are shown in the column chart visual
Hi @sperry ,
Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.
Note: The part with red font is updated one...
Total Cumulative Boosters Required Maori =
IF (
ISBLANK ( [Total Cumulative Eligible Booster Māori] )
|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),
BLANK (),
( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )
)
|
Best Regards
Perfect - works a treat..thanks for that
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |