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.
Hey all
I was wondering i fit is possible to hide the total row/cell for a single column. Or at least give it the value manually. Or change the font settings to make it visible…
In the screenshot below I have the column “col”. It wasn’t possible to count directly by Power BI so this is a custom SQL snippet.
To get the expected result we count all entries, so you get the correct nr of entries per month.
But the total of 228k is wrong. It should distinct count the column, but due to the custom sql code not possible.
I did not find any method to hide the value or change it manually. Setting a white box over it does only work as long as the user don’t change the month/quarter filters…
Thank you and kind regards
Solved! Go to Solution.
Hi @Anonymous
Basically, you could average with this formula
Measure 2 = IF(HASONEVALUE(Sheet1[H]),COUNT(Sheet1[COL]),AVERAGEX(Sheet1,COUNT(Sheet1[COL])))
If it doesn't give the correct result, please give an example of your expected output based on my test data.
Best Regards
Maggie
You could change the text color for the total of that *specific column* to match the background.
Select do not summarize for the column you don't want the total
Hi @Anonymous
I don't know what do you mean "the total should distinct count the column", so i calculate the total as below.
after add columns in the matrix,
create a measure:
Measure = IF(HASONEVALUE(Sheet1[H]),MAX([COL]),DISTINCTCOUNT(Sheet1[COL]))
Best Regards
Maggie
“
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
“
Thanks for your reply @v-juanli-msft.
This kinda works as i want it to, thank you.
I need the "ELSE" Value to be avg from count(COL). This does not work. If i create a measure that counts COL i cannot use it in the avg function.
How can i achieve that? If not possible, can the "ELSE" Value be blank?
TestMeasure = IF(HASONEVALUE('Table1[H]);COUNT(Table2[COL]);AVERAGE(Count(Table2[COL])))
Hi @Anonymous
Basically, you could average with this formula
Measure 2 = IF(HASONEVALUE(Sheet1[H]),COUNT(Sheet1[COL]),AVERAGEX(Sheet1,COUNT(Sheet1[COL])))
If it doesn't give the correct result, please give an example of your expected output based on my test data.
Best Regards
Maggie
Was able to set it to blank, but want to know anyways if it is possible to set it to avg of count
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |